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?
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.
dbms = xls for older versions of Excel
dbms =xlsx for new version of Excel.
without seeing your code this is only a suggestion
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.
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.
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.
Explore Now →SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.