EXPORTING OR IMPORTING TABLES

[Tom]

I need help with either importing or exporting tables from one Access
database to another Access database. The tables from the two databases have
the same names. The data in the tables from one database are more current
than the other. To keep from having to redo all of my queries, I want to
bring in the new tables with the new data. If anyone has any help, it would
be greatly appreciated.

Thanks,

Tom

 

[Ken Snell [MVP]]

Is it just a matter that the one table has "better" data than the other
table? If yes, delete the data from the "other" table, then link to the
"better" table in the other database, and run an append query to copy the
data from the "better" table to the "other" table.

 

[Tom]

What I have going on is every couple of weeks I get a new set of 4 tables
with our inventory items up to date. They contain data from the tables I
already have, which may have had various codes or notes or other fields
changed, as well as any new items that may have been added to the inventory.
The 4 different tables are always named the same thing, (i.e., TABLE1,
TABLE2, TABLE3, TABLE4). So all of my queries are linked to the same tables
each time. What I need to do is to bring in the new tables each time and
replace the old tables and have the queries still work. I've tried importing
and exporting from one database to the other, but I keep getting an "INVALID
ARGUMENT" error. I hope this explains a little better.

 

[Ken Snell [MVP]]

What I suggested is not an import process, but rather linking to the "new"
data table and doing an append query (after you run a delete query on the
"original" table). Have you tried this approach?

 

[Tom]

I tried this and everything was going okay until I got to the third table. I
did everything the same way, but I keep getting an "Invalid Argument" error

 

[Ken Snell [MVP]]

Invalid Argument is an error that can be caused by many sources, depending
upon what you're doing at the time it happens.

Please give us details about what action you were doing when the error
occurred... if during the running of the append query, post the SQL
statement of the query that you're using.

 

[Tom]

I finally got it to work. I had the link going the wrong way. I was linking
the new tables to the old ones. I tried it the other way and everything
worked fine.

Thanks for all of your help.

 

[Ken Snell [MVP]]

Glad to hear it.

--

Ken Snell
<MS ACCESS MVP>

I finally got it to work. I had the link going the wrong way. I was
linking
the new tables to the old ones. I tried it the other way and everything
worked fine.

Thanks for all of your help.

 

[Tom]

Ken,

I tried linking and deleting and appending the tables again and I keep
getting the Invalid Argument again and this time I can't seem to get it to
work. What I did was link the new tables in the new database to the old
database. Then I ran a delete query on the old table and tried to do an
append query from the linked table to the old table and I get the Invalid
Argument. This is what's in the SQL VIEW;

INSERT INTO F4102
SELECT F41021.*
FROM F41021;

Is there something I'm doing wrong?

Thanks.

Tom