Topic: Excel import ODBC error
Hi all,
Is there anything special I need to do to import and Excel spreadsheet? I ask this as I've been requested to test this as part of my migration testing which after a month has yet to be resolved. The necessary Excel ODBC drivers are installed and configured to import a named spreadsheet yet it fails to open the said spreadsheet with the following exception message : "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."
I suspect it is something simple...
Les
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme