Problem when doing INSERT INTO <linked_table> SELECT * FROM <Access_table>

E

einat lapid

Hi,

I'm trying to upload rows from Access table to SQL Server table. I did the
following :
1) Create linked table pointing the sql server destination table

2) Upload rows by : INSERT INTO <linked_table> SELECT * FROM
<Access_table>


It worked fine with limited number of rows but when I tried oploading
many rows(1000000) then I got
"System resource exceeded". I don't have any resource limitation on
my system.

Any idea how to resolve this problem ?

Thanks,

Gil
 

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

Uploading data from access to SQL Server 4
Append Access Data to SQL Server Table 12
Unable to update a linked table 2
Insert Rows from One Table To another 2
How can I speed up doing loads of "INSERT INTO" statements 3
Access 2003 and SQL Server 2000 Linked Tables 1
System resource exceeded 2
Using ODBC Linked Tables 10

Top