Hello,
I ave a bit of a dilemma. I ahve a client that wants PeachTree data in an Access database. I had the client export the appropriate data from PeachTree (Customers and Inventory). It is quite a simple list of items the customer export has only the customer ID and the Customer Name and the inventory export only has the Item ID and the Item Description. The rub is that the client can't seem to export only new data (ie. new entrys since the last export). The dump the whole shebang. So when I import it just takes the whole Excel file and appends it to the existing table. So I have duplicats all over the place (I had to create my own primary key in the table I import into because the Customer ID is not unique). So essentially I need to take the imported data and slog through it and find only the new data and append that to the tables(customer and inventory).
Is there a quick and easy way to do this or is the import/append gonna be a slow process (import into temp table and run a comparison query be fore the append)?
Thanks for your help!!
Joe
I ave a bit of a dilemma. I ahve a client that wants PeachTree data in an Access database. I had the client export the appropriate data from PeachTree (Customers and Inventory). It is quite a simple list of items the customer export has only the customer ID and the Customer Name and the inventory export only has the Item ID and the Item Description. The rub is that the client can't seem to export only new data (ie. new entrys since the last export). The dump the whole shebang. So when I import it just takes the whole Excel file and appends it to the existing table. So I have duplicats all over the place (I had to create my own primary key in the table I import into because the Customer ID is not unique). So essentially I need to take the imported data and slog through it and find only the new data and append that to the tables(customer and inventory).
Is there a quick and easy way to do this or is the import/append gonna be a slow process (import into temp table and run a comparison query be fore the append)?
Thanks for your help!!
Joe