Exporting Table Field Data

[shankbanta]

I am using Access 97. I have recreated a database with some major Table structure changes. Actually I normalized the table creating 3 tables from 1.

Question:
Is there a way I can export field data from the old db table into the new db tables.

Example:

OldTable NewTableComputer NewTableMonitor Workstation
ComputerID ComputerID
User User
Asset# Asset#
Monitor# Monitor#
MonitorAsset# Asset#


I hope this keeps it's format. Of course there are more fields, this is just a sample.

Thanks

 

[shankbanta]

Well it did not keep it format.

New Tables:

Computer ->ComputerID, Asset#
Monitor -> Monitor#, Asset#
Workstation -> User, Location

Hope this clarifies things.