G
Guest
Hi All,
Our office is currently running a dinosaur of a character based ERP. We
are, however, able to dump our data into Excel. What we’re looking to do, on
a weekly basis, is import the ERP’s Products table into Access from Excel
(50,000+ records). Should we import our data into a new table every week,
and then run a duplicates query to eliminate the duplicates before appending
to the main table, or is there a better way, considering we probably add less
than 50 records per week?
Thanks for any advice.
Our office is currently running a dinosaur of a character based ERP. We
are, however, able to dump our data into Excel. What we’re looking to do, on
a weekly basis, is import the ERP’s Products table into Access from Excel
(50,000+ records). Should we import our data into a new table every week,
and then run a duplicates query to eliminate the duplicates before appending
to the main table, or is there a better way, considering we probably add less
than 50 records per week?
Thanks for any advice.