Importing Lookup tables

  • Thread starter Thread starter Alan Fisher
  • Start date Start date
A

Alan Fisher

I'm looking for the best way to import some lookup tables
at startup. I tried using a make table query but when the
table is created it has the subdatasheet name set to auto
which slows data access. Any help would be appreciated.
 
I'm looking for the best way to import some lookup tables
at startup. I tried using a make table query but when the
table is created it has the subdatasheet name set to auto
which slows data access. Any help would be appreciated.
Click to expand...

Try using the TransferDatabase method to import the table instead.

John W. Vinson[MVP]
 

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

transferspreadsheet query - adding duplicates to lookup tables 2
Lookup Table for Client Names 1
Set subdatasheet name to none when upsizing to SQL? 9
Importing data into a Lookup Field 2
Object dependencies vs. relationships 4
Table lookups with queries 8
Lookup query allows me to retrieve up to two rows. 1
Replacing a Table with a Table from another database - reference issues 1

Back
Top