I am trying to pull in over 40 tables with anywhere from 2 to 10 thousand records, from across a network. As you can probably guess this process is rather slow. About an hour and a half. I have tried using the transferDatabase method, then I thought maybe it would be faster if I ran a query on the external databases. I have tried and append query and a make table query but they do not help much. Are there any other alternatives for making this any faster. The hardest questions always have the easiest answers.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cross Network Data
- Thread starter jtmach
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question