By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,376 Members | 3,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,376 IT Pros & Developers. It's quick & easy.

Downloading large table

P: n/a
I need to import a large table from server into Access everyday. The
import procedure from File -> Get External Data -> Import is very slow.
I was thinking about FTP but was told that it's only for files, not
table. Can anyone suggest how to automate this download process?
Thanks in advance.

Jan 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
By Server do you mean SQL Server?
If so, you should drive the process from that end (if you have access).
The Import/Export data wizard in Enterprise Manager is easiest way to
go for a simple export.

Exquisitus wrote:
I need to import a large table from server into Access everyday. The
import procedure from File -> Get External Data -> Import is very slow.
I was thinking about FTP but was told that it's only for files, not
table. Can anyone suggest how to automate this download process?
Thanks in advance.


Jan 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.