Table transferring HELP!!!!

[Guest]

I have a 100 spreadsheets comming into a folder and i need to transfer them
into a table.

my question is this

how do i import data in fields that are exactly the same in my table in
access from a table in excel and add them to the table not delete current
data and replace with the new

thanks again for your time peeps

 

[tina]

using a TransferSpreadsheet action in a macro or VBA will *append* the data
as new records in an existing table. it does not overwrite existing records
in the table.

hth

 

[Guest]

sorry new to tis can i ask what vb would do this ois there a specific command
in a macro that im missing

 

[pietlinden]

sorry new to tis can i ask what vb would do this ois there a specific command
in a macro that im missing

TransferSpreadsheet. Do the first import manually, create an import
specification, save it, and use that in your code when you automate
it. If you've never written VBA before, dig around here. There are
several postings describing how to process an entire directory/folder
of files. the one I borrowed Brendan Reynolds posted quite a while
ago.