Importing xls into existing table

J

John G

I want to import an excel spreadsheet into an existing
table but the import wizard won't let me do this (the
existing table option is greyed out). How do I change
this setting if at all possible??
thanks in advance,
john g
 
J

Joe Fallon

Use TransferSpreadsheet in code:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8,
strTableName,
strLocalDir & strLocalFileName, True
 

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

Similar Threads

Import Excel File into EXISTING Access Table 2
Something changed but I didn't do it. 5
Import errors importing Text into existing table, header vs no hea 3
Importing text into number field- Error 4
Type Conversion Failure importing number as text 1
Importing Excel Data into MS Access Table 1
Import new data and replace old data in Access table. 4
Import Table Wizard not working 1

Top