Import tables on startup

  • Thread starter Thread starter alan fisher
  • Start date Start date
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.
 
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.
 
Back
Top