Merging files

  • Thread starter Thread starter Michael Pallamary
  • Start date Start date
M

Michael Pallamary

Hello,

Is there an easy way to merge data files in Access? The
data is all in the same format. I just need to merge it
all into one file.

Thank you for your time.
 
Hi Michael,

It depends on what you mean by "data files". But in general:

1) open the database you want to merge the data into.

2) use File|Get External Data|Link to create linked tables accessing the
data in the other files.

3) create a series of Append queries to append the data from the linked
tables into the table(s) where you want it.

Hello,

Is there an easy way to merge data files in Access? The
data is all in the same format. I just need to merge it
all into one file.

Thank you for your time.
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
i've tried merged all data from same field but different
databse... still can link the data.. help me...
-----Original Message-----
Hi Michael,

It depends on what you mean by "data files". But in general:

1) open the database you want to merge the data into.

2) use File|Get External Data|Link to create linked tables accessing the
data in the other files.

3) create a series of Append queries to append the data from the linked
tables into the table(s) where you want it.

Hello,

Is there an easy way to merge data files in Access? The
data is all in the same format. I just need to merge it
all into one file.

Thank you for your time.
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top