How do I automate a reoccuring data load from Excel to Access?

A

Andrewrccl

I need to update an Access database weekly from an excel spreadsheet
generated from one of our systems... In doing so, there is some basic
transforms to do one the data before it is dumped in...
Is there an easy/good way to do that?

thanks!!
 
K

Klatuu

One way is to link to the spreadsheet as if it were a table. Then use an
append query that can do the data transformation and append records to your
Access tables at the same time.

It may be necessary to use recordset processing to do this if the
transformation can't be done with SQL. But, avoid using any make table or
temporary tables as they are big contributers to database bloat.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Exporting Data from Access To Excel 10
Export Data from an access table to a pre-formatted excel template 1
How do i update Access Table using data from Excel spreadsheet 3
Importing data from Excel into Access 1
Import Updated Data from and Excel to Access 2
Automate Export to Excel upon Close of Database? 1
Export Data from Excel into Access 5

Top