topic Re: Help: ERROR: DBMS type EXCEL not valid for import. in SAS Programming

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

GeethaMN — Mon, 15 Jun 2015 12:51:55 GMT

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.

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

ChrisHemedinger — Mon, 15 Jun 2015 13:16:39 GMT

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

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

Ksharp — Mon, 15 Jun 2015 13:53:37 GMT

Then try other Engine. Like XLS XLSX .

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

DanielaNRW — Fri, 19 Jun 2015 10:40:45 GMT

Maybe the engine "ExcelCS" would also work.

Which SAS Version are you using?

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

rahul88888 — Wed, 22 Jul 2015 07:50:08 GMT

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.

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

SASKiwi — Wed, 22 Jul 2015 07:59:15 GMT

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

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

RW9 — Wed, 22 Jul 2015 08:08:07 GMT

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.

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

mathias — Mon, 23 May 2016 13:10:36 GMT

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

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

osmelbrito — Thu, 18 Aug 2016 20:57:42 GMT

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?

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

L_R — Thu, 29 Sep 2016 19:46:42 GMT

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

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

mojerry_realdolmen — Sat, 31 Dec 2016 10:52:31 GMT

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

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

cmallon — Mon, 19 Feb 2018 09:46:34 GMT

I have the same ERROR while using PROC IMPORT with excel files. I have checked and my Guide version is 64-bits but my office is 32-bits... which is the solution to this ?

Thanks!

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

dscj — Fri, 15 Nov 2019 15:43:55 GMT

DBMS=XLSX works

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

SamuVittorel — Thu, 11 Jun 2020 19:04:24 GMT

This helped me a lot!!! Thanks buddy!!!

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

A66 — Tue, 27 Oct 2020 01:31:36 GMT

Below is the proc export statement:
Proc export data=myworkbook

outfile="&output.\&File_Name..XLSX"

dbms=Excel replace;

sheet='mysheet1';

I'm getting this Error: my workbook.DATA does not exist.

Need help??

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

SASKiwi — Tue, 27 Oct 2020 01:52:43 GMT

@A66 - Please create a new post. Your problem is completely different from this one. As a general rule always start a new post for a new problem.

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

firdovsi9 — Fri, 20 Nov 2020 06:04:49 GMT

Thanks, it helped me too