Importing from Excel to Access

Have you tried linking the table instead? Often that's a better solution than an Import. If you need to persist the data locally, you can still link the Excel file, and then run code to save the linked data to an Access table. Doing this also gives you a chance to validate and verify information before it's imported.

instead of creating a table by importing, create the structure first and then import into it by appending. If you do create by importing, it is a good idea to put a dummy row first that will be deleted after importing that has an example value in every field. Not sure, however, a table created by importing will choose Long Text if dummy text is more than 255 chars.  Other problems with import table definitions include format code for text fields that will truncate to 255 (remove this after import, along with other field properties you don't really want).  In table, put an autonumber ID field last since it will not be in your data and is a good idea to have.