Auto Import

P

Paul Allen

Hi

Can you tell me if there is a way to set up a vb script
or a macro to import a table from another database?

I am on holiday for 2 weeks and somebody to needs to run
off some reports. Usually I import the table from the
live database and run the reports from there. If I could
automate the import it would help.

Thanks
 
J

John Nurick

Hi Paul,

Access has both macros and the VBA programming language. Macros are
simpler to get started with, but VBA is immensely more powerful in the
long run.

If all you need to do is to import a table and run some reports, a macro
is probably all you need. Use the Insert|Macro menu command to get
started; and use the TransferDatabase and OpenReport actions.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Automate Import of Spreadsheet to Backend from Frontend 1
Importing import specs 0
Reusing saved import instructions 0
Importing a file from another database 2
Adding a big matrix in Word 2013 5
Word VBA - Want to test if Full Name is NOT Present in document 0
Criteria for importing tables from a odbc link 2

Top