Import excel data in to SQL Server
Hi Folks,
we have developed an asp.net based application to import invoices data which we receive in excel sheets into sql server using ACE.OLEDB.12.0. All of the sheets had the first row as a column name and it was easy to import data from them.
I have received a new sheet from supplier (please see attachment) which we need to automate. It would have less than 300 rows. The trouble is the first row is not the header. Infact the first 3 rows makes a unique colum name. Can some one suggest how can I consolidate first 3 rows to make the first row as header with unique column names.
if macro is the solution then could you please assist how to write this one as i don't have exposure to vba.
Thanks
|