Home Forums SQL Server 2008 SQL Server 2008 - General Importing from a improperly formatted excel file RE: Importing from a improperly formatted excel file
Mr. Kapsicum
SSCertifiable
Points: 6128
More actions
September 27, 2013 at 4:51 am
#1653958
well i guess,,,,,, SSIS package (Data Flow task ) may help you in this.
IF,Number of columns in your excel files are going to be fix.....Then u can pump "N" number of rows into your Database tables.