Exporting/Importing - Error!

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

alish

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.

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

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.
 
Dave, no code is invovled here. I am just simply trying to move one table
from one db to another one. It gives me 'Invalid Argument' error message. And
after all I am not abe to do any table tasks on that spesific database like
creating a table or saving changes on the existing tables. i am trying to
find out what causes that error. Thanks in advance for your help. Alish.
 
You have to have some code, even if it is a macro that is trying to do a
TransferDatabase.

As to any table actions, you have to be in the database where the table is
to make any modifications to it.

How are you trying to import the table?
 
I tried several ways: macro TransferSpreadsheet, drag and drop, Export, yet
did not work. Thanks.
 
TransferSpreadsheet should do it. Review the information in VBA Help to be
sure you are passing all the information it needs correctly.

Without seeing what you are entering in the macro, I don't know how I can
help.
 
Back
Top