Data Extraction

Im working on a university project and I need to extract data from an Access 2 database into an existing Access 97 database. The fields in the A2 database are different to the field names in the Access 97 database. Does anyone have any advice to how I should approach this?

Hi Raje,

Actual names of the fields are unimportant, what will be important is to have each field contain the same data type. If all you want to do is get all the records from the table in the Access 2 database and append them to the Access 97 table, then use a query to arrange the fields in the Access 2 table to match the fields in the Access 97 table in the exact order, then copy all the records from the query and use the paste append from the file menu to add those records to your Access 97 table. Another method would be to import the complete table into your Access 97, then use an append query to match up what field from the Access 2 table goes to which field in the Access 97 table.

lwells