This is a new one for me. One good thing working with Excel and Access is the Copy/Paste ease between them. I usually paste data from Excel to Access for these two reasons:
- Create tables in Access (for small tables)
- Paste Field names: either in a table or in the import specs form
When I am importing data of the web, usually they have field names and data types given that page, so it makes sense to import that table in Excel (using Import from Web option), and then copy the field names and directly paste them the import specs form in Access. However, I kept running in this error today, which MS acknowledged and provided a solution, caused due to a security patch.
I used a workaround to paste those field names: copy and paste the data in a text file, and the again copy and paste it in Excel.