etm124 etm124 - 2 months ago 8
SQL Question

Opening rowset for "September$" failed. Check that the object exists in the database

I'm getting the following error when trying to import an Excel file into my database.

I have tried both importing the data into an existing table, and also letting the Import Wizard create a new table.

When checking the mappings, everything looks good. Any insight into this error would be greatly appreciated.

Here is a screenshot of the error:

enter image description here
enter image description here

EDIT: Here is where I am defining the source/destinations:

enter image description here
enter image description here

Answer

This problem is being caused by spaces in the name of your Excel file. If you replace the spaces with underscores the error will go away. Change file name from this:

September Bioreference.xlsx

to this:

September_Bioreference.xlsx