469,904 Members | 2,046 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,904 developers. It's quick & easy.

Invalid Argument for large import or link

Peeked around here but didn't really see an explanation as to the
varied "Invalid Argument" errors that appear in Access sometimes. I'm
using Access 2003 and trying to import an Access table of ~200,000
records into my DB. I've tried importing, linking, exporting the
original table to txt and importing or linking to that. Then I tried
exporting the table to it's own DB (which worked) but still cant then
import or link to the DB I'm using. I get "Invalid Argument" errors.

There's no code or anything and I've repaired and compacted all
relevant DB at least 3 times each, rebooted, shut down and restart and
nothing works. This happened to me about 2 yrs ago with importing
"large" files and seems like an Access bug, but is there anything that
can be done??? I've wasted a day already trying to get this data in!!

Thanks,
Darrell

Oct 20 '06 #1
2 6389
Try setting up an append query that only transfers maybe a fourth of your
import data at a time

Kevin C
<ve***@aol.comwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
Peeked around here but didn't really see an explanation as to the
varied "Invalid Argument" errors that appear in Access sometimes. I'm
using Access 2003 and trying to import an Access table of ~200,000
records into my DB. I've tried importing, linking, exporting the
original table to txt and importing or linking to that. Then I tried
exporting the table to it's own DB (which worked) but still cant then
import or link to the DB I'm using. I get "Invalid Argument" errors.

There's no code or anything and I've repaired and compacted all
relevant DB at least 3 times each, rebooted, shut down and restart and
nothing works. This happened to me about 2 yrs ago with importing
"large" files and seems like an Access bug, but is there anything that
can be done??? I've wasted a day already trying to get this data in!!

Thanks,
Darrell

Oct 20 '06 #2
Didn't really work, still got error. Guess my question is that
shouldn't Access be able to handle a table of 500,000 records? This
must be a known issue so are there any system settings, etc. that
should be adjusted to overcome this? Is Microsoft just trying to get
you to move to SQL when you get to a certain point? (I only have 1-2
tables of this size and am not a DBA so not really interested in moving
to SQL, though I do have a MYSQL server and might have to look at that
if I can't get around this stuff.)

Kc-Mass wrote:
Try setting up an append query that only transfers maybe a fourth of your
import data at a time

Kevin C
<ve***@aol.comwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
Peeked around here but didn't really see an explanation as to the
varied "Invalid Argument" errors that appear in Access sometimes. I'm
using Access 2003 and trying to import an Access table of ~200,000
records into my DB. I've tried importing, linking, exporting the
original table to txt and importing or linking to that. Then I tried
exporting the table to it's own DB (which worked) but still cant then
import or link to the DB I'm using. I get "Invalid Argument" errors.

There's no code or anything and I've repaired and compacted all
relevant DB at least 3 times each, rebooted, shut down and restart and
nothing works. This happened to me about 2 yrs ago with importing
"large" files and seems like an Access bug, but is there anything that
can be done??? I've wasted a day already trying to get this data in!!

Thanks,
Darrell
Nov 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Nad | last post: by
4 posts views Thread by bob | last post: by
4 posts views Thread by robert | last post: by
1 post views Thread by max.aginaga | last post: by
25 posts views Thread by tekctrl | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.