Hello All,
I have a Inventory/Workorder database that we haven't done a very good job of keeping the inventory side accurate. Plus there were some design flaws. I have created a seperate database that has fixed most of the issues that we have and I want to take the valid inventory from our first database and import it into our new database. I have marked the valid items and have a query setup to get me the info I want. However the info comes from 3-4 different tables (ie Users table, Hardware table, Software table). When I do an import I only have the choice to add to an existing table or create an new table. How can I say I want these fields to go to this table, these fields to that table and so on.
Thanks in advance
Rick
I have a Inventory/Workorder database that we haven't done a very good job of keeping the inventory side accurate. Plus there were some design flaws. I have created a seperate database that has fixed most of the issues that we have and I want to take the valid inventory from our first database and import it into our new database. I have marked the valid items and have a query setup to get me the info I want. However the info comes from 3-4 different tables (ie Users table, Hardware table, Software table). When I do an import I only have the choice to add to an existing table or create an new table. How can I say I want these fields to go to this table, these fields to that table and so on.
Thanks in advance
Rick
