Importing xls into existing table

  • Thread starter Thread starter John G
  • Start date Start date
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
 
Use TransferSpreadsheet in code:

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