EXPORTING OR IMPORTING TABLES

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

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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

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]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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

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?

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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

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
on the last two tables. I don't know what's going wrong with the last two.
Any ideas or suggestions?

"Ken Snell [MVP]" wrote:

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?

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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
on the last two tables. I don't know what's going wrong with the last
two.
Any ideas or suggestions?

"Ken Snell [MVP]" wrote:

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?

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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

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]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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
on the last two tables. I don't know what's going wrong with the last
two.
Any ideas or suggestions?

"Ken Snell [MVP]" wrote:

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?

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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

Glad to hear it.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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
on the last two tables. I don't know what's going wrong with the last
two.
Any ideas or suggestions?

"Ken Snell [MVP]" wrote:

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?

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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,

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

"Ken Snell [MVP]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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
on the last two tables. I don't know what's going wrong with the last
two.
Any ideas or suggestions?

"Ken Snell [MVP]" wrote:

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?

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Tom" wrote in message
...
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