#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Import Notes Field data along with attachments? | Prabhakar | Project | 0 | 04-08-2011 04:46 AM |
Import Pics and Excel Data into PP? | jawillyams | PowerPoint | 0 | 03-13-2011 01:03 PM |
Outlook data import | Cunner | Outlook | 2 | 08-20-2010 02:03 AM |
*Big One* feeding sql server data into MS Word 2007 forms | vafo | Mail Merge | 0 | 02-03-2010 04:49 AM |
MS ACCESS - Import from Excel problem | Gregory_in_Montauk | Office | 6 | 05-06-2005 08:50 AM |