Limit your file import to no more than 255 columns, which corresponds to the limit of 255 table fields imposed by Access. You can't skip columns when you import into a database that already exists.

The ImportExportSpreadsheet form appears. This form allows you to set up the parameters Access needs to import your spreadsheet. Type the name of your table in the "Table name" text box.

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