Importing Excel Files to Aceess 2003 table with Descriptive header

C

Culliden

I can transfer the Excel file using the Code below. Is there a way to
Transfer/Append the data to an existing table with the Header in the Database
and not the Excle file. My Excel Files are created from an AS400 with short
non descriptive header names. I need the Data appended to my header to have
descriptive names.

DoCmd.TransferSpreadsheet acImport, 8, "ImpSpecificationDetail",
"S:\FTS_LocalDatabases\DataSupport\Support_Files\539BeltSpecs.xls", False,
"A2:IQ"
 
J

Jake

I would set up the table you want it to be in first, then inport the data
using a different table name. Then you can use an insert query to associate
the excel names into the access table and insert the rows you imported. then
simply delete the table you imported leavign the records in the perminant
table with the header you want it to have.

Jacob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top