Forum Discussion
Access: Import XLS error using import wizard
getting "Automation Error Element Not Found" when using access External Data - New Data Source - Excel file - the file i tried to import was new and empty -
Resolution
Use the *.xlsx format instead.
Restrict any memo/long text fields to a length less than 8224 bytes.
When exporting, delete the existing .xls file before performing the export using the same file name.
Open the .xls file in Excel before performing the Import/Export from Access.
Regards,
Will
Use the *.xlsx format instead.
Restrict any memo/long text fields to a length less than 8224 bytes.
When exporting, delete the existing .xls file before performing the export using the same file name.
Open the .xls file in Excel before performing the Import/Export from Access.
Regards,
Will