03-25-2014 02:17 PM
I'm trying to use proc sql pass through with excel. I have had the same code and used it for awhile, but now I am getting an error that states the microsoft access engine could not find the object. Any suggestions on how to fix this problem?
03-25-2014 03:28 PM
Have you changed your version of Excel or your ODBC drivers? Or your OS? A lot of moving parts in such a system.
Always helps to post your code as well.
03-25-2014 03:53 PM
No changes. Here is a copy of the code and error:
proc sql dquote=ansi;
connect to excel (header=yes path="&filepath.\&filename.");
create table jude.sampling as
select * from connection to excel
(select * from strata);
ERROR: Describe: The Microsoft Access database engine could not find the object 'strata'.
Make sure the object exists and that you spell its name and the path name correctly. If
'strata' is not a local object, check your network connection or contact the server administrator.
As you can see, I am not trying to use access but excel. The name and path are correct.
03-25-2014 04:53 PM
Is Strata a sheet name or a named range?
Also, does the case match, ie strata vs Strata
Strata was a sheet name and they were the same.
Next time I will try to be more clear from the beginning.