mcrmg
asked on
import from Excel to SQL
Hi,
I have an Excel file that contains several date columns. I need to import them into SQL. (see attached)
When I tried to import into SQL, I got errors that there were some issues when converting the data. If you look at the file, the data is not consistent. Some dates are listed as
6/13/2007
20040407
Is there a way to solve this problem? thanks
test.xlsx
I have an Excel file that contains several date columns. I need to import them into SQL. (see attached)
When I tried to import into SQL, I got errors that there were some issues when converting the data. If you look at the file, the data is not consistent. Some dates are listed as
6/13/2007
20040407
Is there a way to solve this problem? thanks
test.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER