Does anyone know how to import excel data into into an Access table and replace the existing data? For example let's say I have an excel spreadsheet with 1st column labeled Name and second column ...

I am using Excel 07 and Access 07. We have this shipping software that integrates with our UPS and FedEx shipper accounts and also our ERP system. Each day, the shipping software generates these files ...