DATA Step, Macro, Functions and more

Help: ERROR: DBMS type EXCEL not valid for import.

Reply
Occasional Contributor
Posts: 15

Help: ERROR: DBMS type EXCEL not valid for import.

Log:

6    proc import datafile = 'D:\Bangaloreusers\BSRZR05315\TrainingMaterial\Data\Session 6  ! 1\Data\sample_data.xls' 7                    out = ds_imprt 8            DBMS = excel replace; ERROR: DBMS type EXCEL not valid for import.

Please help me out in debugging this error.. occurring while reading excel sheet with Proc Import to create SAS dataset.

SAAAS
Community Manager
Posts: 2,955

Re: Help: ERROR: DBMS type EXCEL not valid for import.

Moderator Note: I updated the topic title to make this message more readable.

Super User
Posts: 10,045

Re: Help: ERROR: DBMS type EXCEL not valid for import.

Then try other Engine. Like  XLS  XLSX .

Occasional Contributor
Posts: 13

Re: Help: ERROR: DBMS type EXCEL not valid for import.

Maybe the engine "ExcelCS" would also work.

Which SAS Version are you using?

Contributor
Posts: 31

Re: Help: ERROR: DBMS type EXCEL not valid for import.

Hi, Geetha

In case you are using a unix based SAS it will not work . you wont be able to import and excel file

Excel is not supported on Unix..

Your best thing is to export the Excel file to a .CSV file and read it in that way.

Super User
Posts: 3,260

Re: Help: ERROR: DBMS type EXCEL not valid for import.

If you want a quick fix, save the spreadsheet as a CSV then use DBMS = CSV.

Super User
Super User
Posts: 7,994

Re: Help: ERROR: DBMS type EXCEL not valid for import.

I agree with SASKiwi, but not just for a quick fix.  Whenever "Excel" is used in a post, I would always recommend getting the data out of Excel into a proper data transfer format (CSV, XML etc.), then write a proper datastep import to import that transfer file format.

Frequent Contributor
Posts: 127

Re: Help: ERROR: DBMS type EXCEL not valid for import.

I have the same error, still looking for a solution.

 

I can't export to CSV manually because I have lots of sheets.

 

(Or is there a way to export xls sheets to csv from SAS with another method? like x maybe ?)

 

ERROR: DBMS type EXCEL not valid for import.

 

 

I'm working with SAS 9.3 in SAS EG 5.1 (5.100.0.12019) (64-bit) on Windows7

Occasional Contributor
Posts: 18

Re: Help: ERROR: DBMS type EXCEL not valid for import.

I also have the same error. I have xlsx files and I'm trying to import in a SAS Linux Server (SAS 9.4) and get message DBMS type Excel is not valid

 

Have you ever found any solution?

Contributor L_R
Contributor
Posts: 24

Re: Help: ERROR: DBMS type EXCEL not valid for import.

Posted in reply to osmelbrito

Anyone has any solution for .xls, .xlsx files? Please share..

Trix
Occasional Contributor
Posts: 14

Re: Help: ERROR: DBMS type EXCEL not valid for import.

Hi,

 

If you're using eguide 64 bit then you need to check if your office installation is also in 64 bit.

oter solution is to use the access to pc file server.

 

kind regards

Ask a Question
Discussion stats
  • 10 replies
  • 8644 views
  • 1 like
  • 11 in conversation