Software

Ask something
Discussion Locked

Importing Data to Access 2002

0 helpful
7 replies

by carljohnman

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I was asked to make a database to replace the current program used ( Microsoft Works ). I do not see any problems making the forms, queries, extc.. but I have 3 workbook databases they want converted into one ( year 2000, 2001, 2002 ). I saved them as dbase1V, opened them in excel, repaired some errors, and then opened 3 seperate tables for them in Access. I want to know if anyone knows a better process?, and most important how to merge the tables and when I am done with that making a "UPDATE QUERY" to retrieve the information being entered currently while I am in development from the 3 seperate Works databases.

Thank you very much for any help in advance and if possible please be specific in your help.

Carl Johnman
carljohnman1819@msn.com

7 replies

by vinnyd

Importing them into 3 separate tables is an ok way to do it.

You would use an Insert SQL query to merge them together. Once you are sure the merge worked ok you can delete the old 3 tables.

the insert query is simple:

INSERT INTO NewTable SELECT * FROM dbaseiv_table;

Just repeat the insert query using the correct dbase iv import table names in place of dbaseiv_table.

Use whatever name you want for NewTable.

by wan_fai

Hi,

If the format of three databases are the same, you could import open them in Access. And create a new access database. Then, you could select "Import From" in the menu to import the 3 tables into the new table.

I think it is no need to useSQL command.

Good Luck

by zencoyote

The way you've done it sounds fine. Create a new table with the fields set up exactly how you want them, then use Append queries to read up the data from each of the three tables into the new table.

This discussion is closed to new replies.