DATA Step, Macro, Functions and more

Proc sql pass through with excel

Reply
New Contributor
Posts: 4

Proc sql pass through with excel

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?

Super User
Posts: 17,824

Re: Proc sql pass through with excel

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.

New Contributor
Posts: 4

Re: Proc sql pass through with excel

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.

Super User
Posts: 17,824

Re: Proc sql pass through with excel

Is Strata a sheet name or a named range?

Also, does the case match, ie strata vs Strata

New Contributor
Posts: 4

Re: Proc sql pass through with excel

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.

Respected Advisor
Posts: 4,646

Re: Proc sql pass through with excel

If your file is .xlsx, try to convert it to older format .xls and see if you can access that.

PG
New Contributor
Posts: 4

Re: Proc sql pass through with excel

Thanks all, I found I had to put my worksheet name in [strata$] and that worked.

Ask a Question
Discussion stats
  • 6 replies
  • 413 views
  • 0 likes
  • 3 in conversation