Home Forums SQL Server 2008 SQL Server 2008 - General Importing improperly formatted excel file RE: Importing improperly formatted excel file
watchgeek
SSC Veteran
Points: 291
More actions
May 20, 2014 at 5:57 pm
#1715193
I finished this task with ssis.
I used sql command to import from excel.
select f1,f2 from [sheet1$] where f1 like '[0-9]%'
and do it for other columns.
put them in 2 columns with Union All
get the date with VB and array.