Automate import of ODBC (SQL) Data

[xsnrg]

I have a reporting database that uses a very large set of SQL data as the backend. In order to speed up my application, instead of linking to the SQL database, I have other Access backend files that I import the SQL table into and those Access files become the back-end of my reporting app.

Question: Is there any way to automate this import process. Code I can put in the front end file that would allow me to do the following...
* Delete the tables in another backend file
* Import (with a password) select tables back into this backend file from the SQL database
* Repeat this process for 22 tables in 5 separate backend files

 

[HBWAL]

Have you tried DTS? My favorite website is sqldts.com. I use it to do all of my automated imports. The only time I seem to have a problem is with excel. If you know VB the activex scripts are a cinch. Loop at his looping example, I use something similar for sql data.