Import tables on startup

A

alan fisher

I need to be able to import some lookup tables on startup.
I have tried using make table queries but the tables they
create have the subdatasheet name set to auto. Is there a
better way to acomplish this task possibly with some VBA
code? Thanks for any help.
 
K

Klatuu

Why is [auto] a problem? that is the default for all tables as far as I know.
If you want to empty it, you could do some VBA that would set it. I think
you can do it with a macro, but I don't do macros, so I don't know for sure.
 

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

Proposal template with removable sections 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Consolidation Table from Different Excel Tabs with Different Format 1
List all tables, including document structure 0
Appending tables 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Adding data to MS Access from csv file 0
Excel - Wich Function should I use? 1

Top