I got assigned to do a little MS office work today, which includes importing some big (1mb) excel spreadsheets into an Access database file, and I only know the basics for these two programs. When I ...

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 ...