Table Importing/Exporting - Errorr message!

  • Thread starter Thread starter alish
  • Start date Start date
A

alish

ALL, CAN YOU PLEASE GIVE ME YOUR ADVICE OR HELP ON SOLVING THE FOLLOWING ISSUE:
I am trying to Import a table from one DB to another. It gives me errorr
message: "Invalid Argument". The tables are quite big. Each has in average
300,000 recs. It cause another problem: after that message I am not able to
use that database as fas as even creating a new (blank) table. I tried to
Repair Access aplication. Still did not work. I would appreciate if you help
me with this issue. Thanks.
 
ALL, CAN YOU PLEASE GIVE ME YOUR ADVICE OR HELP ON SOLVING THE FOLLOWING ISSUE:
I am trying to Import a table from one DB to another. It gives me errorr
message: "Invalid Argument". The tables are quite big. Each has in average
300,000 recs. It cause another problem: after that message I am not able to
use that database as fas as even creating a new (blank) table. I tried to
Repair Access aplication. Still did not work. I would appreciate if you help
me with this issue.  Thanks.
Click to expand...

try a compact/repair before exporting?
are you running out of memory when you export? (show the performance
monitor before you start the process so you can tell...) Are you
doing the export in code or through a macro? It looks like if you do
a TransferSpreadsheet in a macro, it for some reason uses an implicit
transaction, so it succeeds, whereas I have tried it in code without a
transaction and it crashes the database.

Hope that gets you started...

Pieter
 
Pieter, I tried compacting/repairing, and also tried the way you suggested.
Still gives me "Invalid Argument" message. I did have enough memory to run
it. It does not even try, the message appears immediately. Thanks in advance
for help.
 
Back
Top