VBA import and append data to table

[psrs0810]

I have been a user of Access for many years, but never built anything. How do I setup VBA to import and append data to a table?
Thanks

 

[Joe4]

At the same time?
There really isn't a good direct way to do that. You can either do an Insert/Append (add new records), or an Update (update existing records), but not both simultaneously (unless you create some custom VBA code to loop through recordsets, etc).

If you need to do both, one way that I have seen done many times is to import the data to a blank temporary table. Then create two queries from this:
- One to identify changes (can do a Matched query against your existing permanent data table), and make those changes via an Update Query
- One to identify new records (can do an Unmatched query against your existing permanent data table), and add them via an Append Query

And then run each query.

People will often automate many of these steps via a Macro or VBA code.

 

[psrs0810]

let me clarify
There will be a table called ChargeDetial, this table will house charges up to a certain date range. what I need to do, is import the latest file and append the information to this table.

 

[Joe4]

If, by Append, you simply mean "add new records to the table", you should just be able to Import the records directly into the table.
It is pretty straightforward. There is even a Wizard that will walk you through it.

Just go to the "External Data" menu, go to the "Import & Link" ribbon, and select the correct data source (Excel, Text file, etc), and it will initiate the Wizard.