03-13-2015 12:06 PM
I have a problem to import an excel file with xls = dbms.
I have a datetime field format var1 "03/11/2015 10:04:04" with two space between the date and time. When I import the file I truncates the field by putting only the date. How can I import the field as described above?
thank's a lot
PROC IMPORT OUT= WORK.OFFERTE_EB
DATAFILE= "my path"
DBMS=xls REPLACE ;
03-13-2015 12:18 PM
When automatic conversions from Excel fail (moderately often due to Excel users) one solution is often to save the Excel to another format such as CSV an import that file as you can modify the code generated by a proc import call to use custom formats or provide more complicated parsing.