Table transferring HELP!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
sorry new to tis can i ask what vb would do this ois there a specific command
in a macro that im missing
 
sorry new to tis can i ask what vb would do this ois there a specific command
in a macro that im missing
Click to expand...

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.
 
Back
Top