NauticalGent
Ignore List Poster Boy
- Local time
- Today, 02:38
- Joined
- Apr 27, 2015
- Messages
- 6,286
Greetings everyone,
I have about 10 tables that I need to export to an external DB - Linking is not an option
I think if I made a collection of Tables then I could do something like:
I assume this would be the best way to do this - I thought of making a table to hold the table's names and then loop through a recordset but thought this way would be better.
I have tried to add the tables but I keep getting syntax errors - is this even possible?
As always, I am open to suggestions and I thank you in advance!
I have about 10 tables that I need to export to an external DB - Linking is not an option
I think if I made a collection of Tables then I could do something like:
Code:
For Each tdf In myCollectionOfTables
DoCmd.TransferDatabase acExport, "Microsoft Access", "\\ExternalDb", _
acTable, tdf.Name, tdf.Name, False
Next tdf
I assume this would be the best way to do this - I thought of making a table to hold the table's names and then loop through a recordset but thought this way would be better.
I have tried to add the tables but I keep getting syntax errors - is this even possible?
As always, I am open to suggestions and I thank you in advance!