How to import Excel file to Access but the headings have spaces?

[Guest]

I need to import the spreadsheet file regularly to an existing table in
Access where the field names do not have spaces. But because the column
headings of the excel file have spaces the file can't be imported.

 

[Guest]

There are a couple of ways this can be done:
First Way
Create an import table that has the exact same field names as the column
headings in the Excel sheet, including the spaces. Do your import into that
table. You will need to delete all the data in the table before the import.
The create a query to append the data in the import table to your regular
table.

Second Way (My preferred)
Rather than import the Excel sheet, link to it. Then use an append query to
append the data to your Access table. Faster, simpler, and creates less
bloat.

 

[Guest]

Thx a lot, Klatuu. It works!

There are a couple of ways this can be done:
First Way
Create an import table that has the exact same field names as the column
headings in the Excel sheet, including the spaces. Do your import into that
table. You will need to delete all the data in the table before the import.
The create a query to append the data in the import table to your regular
table.

Second Way (My preferred)
Rather than import the Excel sheet, link to it. Then use an append query to
append the data to your Access table. Faster, simpler, and creates less
bloat.

 

[jwrnana]

Can you explain how I link excel and then append??

 

[jwr]

Can anyone direct me to a place to see how to link to excel and then
append???

 

[Douglas J. Steele]

Assuming you're using Access 2002 or Access 2003, you can't anymore.
Microsoft was forced to remove the ability due to losing a lawsuit.

See http://support.microsoft.com/?id=904953