Leigh46137
Registered User.
- Local time
- Today, 11:22
- Joined
- Dec 29, 2009
- Messages
- 12
Strangest problem I've ever seen in Access!
I have an Access 2007 database that needs to import from an Excel file. My code just runs a stored import procedure. When that didn't appear to be working, I tried it manually.
I clicked External Data, Import Excel. Browsed to my spreadsheet and selected to append records to the GroupImport table. The next screen showed my data with the proper column headings matching the field names of the table. (It has only 5 records at the moment for testing, and all are displayed.) I clicked through to fininsh and close. It came back with a message that all objects were imported successfully. I open the GroupImport table and there are NO records.
I don't get any error messages. Everything appears to work correctly, but it doesn't import anything.
Anyone have any suggestions for this?
I have an Access 2007 database that needs to import from an Excel file. My code just runs a stored import procedure. When that didn't appear to be working, I tried it manually.
I clicked External Data, Import Excel. Browsed to my spreadsheet and selected to append records to the GroupImport table. The next screen showed my data with the proper column headings matching the field names of the table. (It has only 5 records at the moment for testing, and all are displayed.) I clicked through to fininsh and close. It came back with a message that all objects were imported successfully. I open the GroupImport table and there are NO records.
I don't get any error messages. Everything appears to work correctly, but it doesn't import anything.
Anyone have any suggestions for this?