Return
-
Title
Access Violation when trying to import an excel file. -
Description
When importing data into a table from an Excel sheet using Database | Import | Import Table Data I received an Access Violation in module Toad.exe.
-
Cause
Corruption with the excel file or data that is being imported.
-
Resolution
Verify if it is a problem with the file itself, or the data in the the excel file.
1. Test import into the same database with a different Excel file, using test data
2. Test import into the same database with a different Excel file, using the same data from the original Excel.
You will need to recreate a the excel file with the data again.