Importing Excel Spreadsheet

D

Don

I have been importing a txt file into my database for years. My work program
now has been updated and the file is now in an Excel Spreadsheet. When using
the import wizard for a text file I was able to create an import spec that
handeled the formatting and renamed each column to match my database. When
using the import wizard with excel the wizard does not allow me to either use
an import spec or import the file using the field format used in my database.
My question is how can I do this using Excel?
 
J

John Vinson

My question is how can I do this using Excel?
Click to expand...

I'd suggest using File... Get External Data... Link to *link* to the
spreadsheet, and then running an Append query to migrate the data into
your table. This will let you flexibly change fieldnames and
datatypes, transform data, etc.

John W. Vinson[MVP]
 
S

Sarah

This doesn't work for MSAccess 2003 (SP2). Any other ways this can be done?
I'd like to be able to append to an Excel file by linking the Excel file then
appending the records, but this feature was taken away in this version. I
lloked at Microsofts work around and it doesn't work the way I want it to.

Any suggestions or web sites that have an alternative work around?

Thanks,

Sarah
 
Top