This post shows you one of the possible problems of the error “The Microsoft Office Access database engine could not find the object” when you are Export from SQL Server database table to Excel.
The full error will be like the following.
Error 0xc002f210: Preparation SQL Task 1: Executing the query “CREATE TABLE `Categories` (
`…” failed with the following error: “The Microsoft Office Access database engine could not find the object ‘Categories’. Make sure the object exists and that you spell its name and the path name correctly.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set correctly, or connection not established correctly.
When you do an Export in SQL Server Management Studio SSMS.
Say you are exporting Categories and Products.
Somehow you hit the above mentioned error.
Do not go and install and uninstall Access Runtime and so. It is as simple as because your fields consist of LongBinary data type.
Ignore that field then you should be good.