We are working hard to make updates to the Shop and Account Management portal.

Please note that many of these changes will roll out this Saturday, June 1st and will require downtime. We are working to ensure minimal disruption for our eOne community and really appreciate your patience as we push out these changes. Please reach out to sales@eonesolutions.com with any questions.

Back

The Microsoft Jet database engine could not find the object

Published: Dec 13, 2016
Post Author Written by eOne Solutions

We are using the Bulk Data Load Data Source Type and Text File Data Source. We can select our file but when we try the preview we get the error message “ERROR [42S02][Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object ‘Customers.2015.12.13.csv’. Make sure the object exists and that you spell its name and the path name correctly.”


The file cannot be read by the Microsoft ODBC Text Driver because there are multiple periods in the file name. The resolution is to remove the extra periods or replace them with underscores.

The same error will occur if using the ODBC Connection Data Source.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.