469,344 Members | 6,124 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Import data (not tables) from one Access database to another?

We've created a new database and need to import the data from our old
database. Both are MS Access databases and each have multiple tables. The
table structure of each table is completely different from each other, but
the actual fields of the data we need to move exist in both tables.

From what I see in the MS Access help I can only find how to import a
complete table from another Access database.

How can I import the data from table 1 of one file into various tables in
the second file?

e.g. Move the like data from the tables in FileOne to the tables in FileTwo.
(notice that the field names may not be the same between the tables)

FileOne.MDB --------
Table1
Name C20
Address C30

Table2
City C20
Phone C15

FileTwo.MDB --------
Table1
Name C20
LandPhone C15 <--data from Phone field in FileONe
CellPhone C15

Table2
Address C30
City C20
Postal C10

Thx!
Nov 13 '05 #1
6 6995
Link to the tables in database1 and use a series of append queries on each table
to move the selected data in each table to the appropriate table in database2.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Noozer" <do*******@me.here> wrote in message
news:D9PNc.131264$ek5.9195@pd7tw2no...
We've created a new database and need to import the data from our old
database. Both are MS Access databases and each have multiple tables. The
table structure of each table is completely different from each other, but
the actual fields of the data we need to move exist in both tables.

From what I see in the MS Access help I can only find how to import a
complete table from another Access database.

How can I import the data from table 1 of one file into various tables in
the second file?

e.g. Move the like data from the tables in FileOne to the tables in FileTwo.
(notice that the field names may not be the same between the tables)

FileOne.MDB --------
Table1
Name C20
Address C30

Table2
City C20
Phone C15

FileTwo.MDB --------
Table1
Name C20
LandPhone C15 <--data from Phone field in FileONe
CellPhone C15

Table2
Address C30
City C20
Postal C10

Thx!

Nov 13 '05 #2
The database application has a function called an "insert query" which will
do exactly what you want in one step. I am new to Access so I don't know if
Access has the same type of query. If not, someone with Paradox can do it
for you and return the data as MS Access tables.

"Noozer" <do*******@me.here> wrote in message
news:D9PNc.131264$ek5.9195@pd7tw2no...
We've created a new database and need to import the data from our old
database. Both are MS Access databases and each have multiple tables. The
table structure of each table is completely different from each other, but
the actual fields of the data we need to move exist in both tables.

From what I see in the MS Access help I can only find how to import a
complete table from another Access database.

How can I import the data from table 1 of one file into various tables in
the second file?

e.g. Move the like data from the tables in FileOne to the tables in FileTwo. (notice that the field names may not be the same between the tables)

FileOne.MDB --------
Table1
Name C20
Address C30

Table2
City C20
Phone C15

FileTwo.MDB --------
Table1
Name C20
LandPhone C15 <--data from Phone field in FileONe
CellPhone C15

Table2
Address C30
City C20
Postal C10

Thx!

Nov 13 '05 #3
> The database application

I meant the database application called Paradox.
has a function called an "insert query" which will
do exactly what you want in one step. I am new to Access so I don't know if Access has the same type of query. If not, someone with Paradox can do it
for you and return the data as MS Access tables.

"Noozer" <do*******@me.here> wrote in message
news:D9PNc.131264$ek5.9195@pd7tw2no...
We've created a new database and need to import the data from our old
database. Both are MS Access databases and each have multiple tables. The table structure of each table is completely different from each other, but the actual fields of the data we need to move exist in both tables.

From what I see in the MS Access help I can only find how to import a
complete table from another Access database.

How can I import the data from table 1 of one file into various tables in the second file?

e.g. Move the like data from the tables in FileOne to the tables in

FileTwo.
(notice that the field names may not be the same between the tables)

FileOne.MDB --------
Table1
Name C20
Address C30

Table2
City C20
Phone C15

FileTwo.MDB --------
Table1
Name C20
LandPhone C15 <--data from Phone field in FileONe
CellPhone C15

Table2
Address C30
City C20
Postal C10

Thx!


Nov 13 '05 #4
What about creating a make table query in the old database to the new database??
"Noozer" <do*******@me.here> wrote in message news:<D9PNc.131264$ek5.9195@pd7tw2no>...
We've created a new database and need to import the data from our old
database. Both are MS Access databases and each have multiple tables. The
table structure of each table is completely different from each other, but
the actual fields of the data we need to move exist in both tables.

From what I see in the MS Access help I can only find how to import a
complete table from another Access database.

How can I import the data from table 1 of one file into various tables in
the second file?

e.g. Move the like data from the tables in FileOne to the tables in FileTwo.
(notice that the field names may not be the same between the tables)

FileOne.MDB --------
Table1
Name C20
Address C30

Table2
City C20
Phone C15

FileTwo.MDB --------
Table1
Name C20
LandPhone C15 <--data from Phone field in FileONe
CellPhone C15

Table2
Address C30
City C20
Postal C10

Thx!

Nov 13 '05 #5
Sorry, an append query not a make table query. You may need to create
a link to the old database to the new database to do the append query.

Once it's done delete the query and the link and you should be set.

Lynn

"Noozer" <do*******@me.here> wrote in message news:<D9PNc.131264$ek5.9195@pd7tw2no>...
We've created a new database and need to import the data from our old
database. Both are MS Access databases and each have multiple tables. The
table structure of each table is completely different from each other, but
the actual fields of the data we need to move exist in both tables.

From what I see in the MS Access help I can only find how to import a
complete table from another Access database.

How can I import the data from table 1 of one file into various tables in
the second file?

e.g. Move the like data from the tables in FileOne to the tables in FileTwo.
(notice that the field names may not be the same between the tables)

FileOne.MDB --------
Table1
Name C20
Address C30

Table2
City C20
Phone C15

FileTwo.MDB --------
Table1
Name C20
LandPhone C15 <--data from Phone field in FileONe
CellPhone C15

Table2
Address C30
City C20
Postal C10

Thx!

Nov 13 '05 #6
"Noozer" <do*******@me.here> wrote in message news:<D9PNc.131264$ek5.9195@pd7tw2no>...
We've created a new database and need to import the data from our old
database. Both are MS Access databases and each have multiple tables. The
table structure of each table is completely different from each other, but
the actual fields of the data we need to move exist in both tables.

From what I see in the MS Access help I can only find how to import a
complete table from another Access database.

How can I import the data from table 1 of one file into various tables in
the second file?

e.g. Move the like data from the tables in FileOne to the tables in FileTwo.
(notice that the field names may not be the same between the tables)

FileOne.MDB --------
Table1
Name C20
Address C30

Table2
City C20
Phone C15

FileTwo.MDB --------
Table1
Name C20
LandPhone C15 <--data from Phone field in FileONe
CellPhone C15

Table2
Address C30
City C20
Postal C10

Thx!

You can temporarily attach the tables, write a bunch of append queries
with the correct criteria (start with a select query first!) and then
run those. Once that's done, you don't need the attached tables
anymore and you can delete them.
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Kajol | last post: by
3 posts views Thread by Jon Ole Hedne | last post: by
5 posts views Thread by strauss.sean | last post: by
1 post views Thread by David Berry | last post: by
7 posts views Thread by Randy | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.