Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-08-2011, 04:49 AM
DavidBrown DavidBrown is offline Import excel data in to SQL Server Windows 7 64bit Import excel data in to SQL Server Office 2003
Novice
Import excel data in to SQL Server
 
Join Date: Aug 2011
Posts: 1
DavidBrown is on a distinguished road
Wink 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
Attached Files
File Type: xls invoice.xls (14.5 KB, 8 views)
Reply With Quote
Reply

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
Import excel data in to SQL Server 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
Import excel data in to SQL Server MS ACCESS - Import from Excel problem Gregory_in_Montauk Office 6 05-06-2005 08:50 AM


All times are GMT -7. The time now is 11:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft