Easiest way to automate running of Saved Imports in Access 07?

G

Guest

Hello,

I have about 100 files that I import into an MS Access 07 table every day.
I've saved the import steps for each as "Saved Imports." I'd like to be able
to run one after the other automatically rather than clicking on each one.

Is there an easy way to do this? Any ideas about macros or steering me in
the right direction would be appreciated.

Thanks and best regards,

Adam H
 
G

Guest

I did more in-depth searching in this forum and it seems like using a macro
and creating a list of TransferText commands will work best. Good stuff!
 

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

Importing Text Files Into Access 1
Access 2007 fails to execute saved XML import 0
Help with Office 07 Access Outlook Add-in..Automating Recurring Ta 1
Automate import of text-files 1
HTML Import not parsing properly when using VB or macro 1
Best way to import text file into existing table on a daily basis 15
Automating Importing files? 2
Best Way to Import Data From a Web Browser 1

Top