Importing excel file to existing table using code

[RamziSaab]

how can u import to a table without deleting existing data in the table...the import wizard has the option but cnt seems to find it in the code??

thnsk

 

[Bastien]

use append

Bastien

cat, the other other white meat

 

[RamziSaab]

I am using:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, strtblname2, Me.txtXLFIle.Value, True, "Access File!" (where do i put append in this?)

 

[Bastien]

doing a little research i think what you might need to do is place the data in a temp table and then run an append query to attach the data from the temp table to the main table then delete the temp table

Bastien

cat, the other other white meat