topic Re: How to check if my excel is a html file in New SAS User

How to check if my excel is a html file

Sk4r — Fri, 08 Mar 2019 21:31:24 GMT

Hi, Ive been having some problem importing an excel file,but when i copy the contents to another excel file of the same type I can import it (in my situation, it was an excel 97-2000 file).

So, is it maybe a html file as excel, or is there another possibility that maybe i didnt notice?

Re: How to check if my excel is a html file

VDD — Fri, 08 Mar 2019 21:56:26 GMT

dbms = xls for older versions of Excel

dbms =xlsx for new version of Excel.

without seeing your code this is only a suggestion

Re: How to check if my excel is a html file

ballardw — Fri, 08 Mar 2019 22:08:05 GMT

If open the suspect file in a text editor and see things that look readable and html tags everywhere and likely mentions HTML in the first row or two, then likely HTML.

Re: How to check if my excel is a html file

Sk4r — Fri, 08 Mar 2019 23:00:07 GMT

Thank you very much, I was struggling like 2 hours looking for a reason to tell my supervisor it was a html, so I needed to move the data to another file.