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?
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.
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.
Is Strata a sheet name or a named range?
Also, does the case match, ie strata vs Strata
Reeza wrote:
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.
If your file is .xlsx, try to convert it to older format .xls and see if you can access that.
Thanks all, I found I had to put my worksheet name in [strata$] and that worked.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.