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

importing Excel data into Access seldom produces the exact table structure you ultimately need. Still, it’s a good idea to let the import process properly arrange as much of the data as possible.

I have a pre-existing table in Access called "CAMPER". I'm importing an Excel spreadsheet to that table which may or may not contain records already in the table.<BR ...