Help, I'm trying to understand a how to fix this error, Microsoft says to do the below, but it's not working.
Can anyone expand this better?
Method 1
1. Import the spreadsheet into a new table named tblTemp.
2. Create an append query to append the data in the tblTemp table to your existing table.
3. Run the append query.
4. Delete the tblTemp table.
Back to the top
Method 2
1. In Microsoft Excel, insert a new first row in the spreadsheet. In this row, add field names that match the field names in the existing Microsoft Access table.
2. In the macro, change the Has Field Names argument to Yes, for example:
Transfer Type: Import
Spreadsheet Type: My_type
Table Name: MyDatabaseTable
File Name: pathname\filename
Has Field Names: Yes
Can anyone expand this better?
Method 1
1. Import the spreadsheet into a new table named tblTemp.
2. Create an append query to append the data in the tblTemp table to your existing table.
3. Run the append query.
4. Delete the tblTemp table.
Back to the top
Method 2
1. In Microsoft Excel, insert a new first row in the spreadsheet. In this row, add field names that match the field names in the existing Microsoft Access table.
2. In the macro, change the Has Field Names argument to Yes, for example:
Transfer Type: Import
Spreadsheet Type: My_type
Table Name: MyDatabaseTable
File Name: pathname\filename
Has Field Names: Yes
