How can I merge tables containing similar data into one table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several tables from Ipaq data collection (seperate dates) that I want
to merge into one table. How can I do this?
 
Paul

I'm not familiar with the Ipaq data collection system.. Can it export data
in the common, standard formats (e,g,., Excel, comma-delimited, ...)?

If so, first export in one of these common formats. What data elements are
contained in the export ... does it include your "separate dates" ... a date
or date/time value?

Open Access to the database window. Use File | Get External... | Import...
(if you want a copy in Access), or use ...|...|Link... if you only want to
form a link to your data source.

Once you have a way to see all your data, you can append all the records to
a table (or more than one, depending on how well-normalized your Access
table structure is).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top