Importing Excel Files to Aceess 2003 table with Descriptive header

  • Thread starter Thread starter Culliden
  • Start date Start date
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"
 
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
 
Back
Top