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...

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...

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...

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...