Importing data in access table

[tommmo]

Hello,
i would like to import data and append it to existing table in access (not overwrite). How to do that? Using of TransferSpreadsheet is not good, because this function simply replaces the existing table...
Actually, my problem is importing data from other sources (xls) into one huge table, so everytime when new xls is available, one procedure should check if there are any new data in xls that doesnt already exsist in master table and if it exsist, then append it to this table.
Any suggestions?
Bye

 

[jioek]

import it into a temp table then append to your table
you can use a macro to do both or use code