Search results

Hi, I've attached a demo Access db. I'm using Access 2007. I am importing an excel spreadsheet, which my organization gets weekly, importing it into Access. It gets imported the table [imported Task list]. From there, an append query reformats it and appends it to my [Master Task List] table...

Re: Query to Convert "Name" field to "Last Name" "First Name" "Middle Name"? I figured it out, thanks again.

Re: Query to Convert "Name" field to "Last Name" "First Name" "Middle Name"? Thank you so much for your replies. I've tried to follow along, and decipher your example database, and am sorry to say I only understood about half of it. Access is quite unlike any other computer stuff I've learned...

Re: Query to Convert "Name" field to "Last Name" "First Name" "Middle Name"? Awesome, thanks, I'll toy with this and post back on my progress. I will have a primary key in the personnel table. Is there an easy way to write a query to simply do the following: 1) lookup the LeadOld in the...

Query to Convert "Name" field to "Last Name" "First Name" "Middle Name"? I have an example database attached. I have many names in a table called "Personnel". The original designer simply built one field called "Name" in which the format is Last First M. As I am undertaking many new upgrades...

Okay, I solved this by using the RunSavedImportExport. (More info on it at http://office.microsoft.com/en-us/access-help/runsavedimportexport-macro-action-HA010171498.aspx , it is not visible unless you enable "show all actions".) I discovered a flaw in that the parameters dropped down list did...

need one more post to be allowed to add my links in the next post below...

Alternatively, is it possible via the macro to call upon a saved import, wherein the fields are already properly matched?

I fear VBA, as it is beyond my experience and understanding. Is there no other way? Else, is there some VBA snippet out there that achieves this, for which I can simply copy and paste? Thanks, Derek

That worked perfectly too! Thanks. I hate to impose on your genorosity, but perhaps you might be able to answer with ease my 3rd and final question? It is at access-programmers.co.uk/forums/showthread.php?p=1136568#post1136568 Thanks you again!

Hi, I have inherited an Access 2007 db. Previously they were importing an excel spreadsheet into a junk table and then running a append query to route the data into the master table. The only reason they used the junk table is because we have more fields in the master than the original source...

Thanks, that worked great. Perhaps you have an answer for my other simple question: access-programmers.co.uk/forums/showthread.php?p=1136422#post1136422 (which is as much about queries as it is about tables)

Will that delete only the records but keep the fields intact?

Okay, and how do I design a delete query?

Hi, I have a database I'm working on, that I inherited, and suffice it to say, there is a database (that we don't own) that we draw data from in the form of an Excel spreadsheet, and then import it into our own Access 2007 database using the import function. We've got it as a saved import, so it...

I have attached an example database. I have a column in the table "tasks" that is text, called "OptionsOld". I have recreated that field as "Options" as a new lookup table, so the datatype is necessarily now a number (connected to the id primary key of the "options" table). In Access 2007...