View Single Post
  #1 (permalink)  
Old April 12th, 2004, 03:07 PM
bmains bmains is offline
Friend of Wrox
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default Excel Data Import


I got to import data from Excel spreadsheets into my database, which is SQL Server. I know you can import the data from excel. However, my data is not formatted in a way which is easily importable. It may appear as below:

C1 C2 C3 C4

Data Data Data Data

The C1-4 are obviously column headers. Anybody have an idea of what I can do in this instance to get the header in with the same row as the columns, so I can import via OLEDB?

This process can be either automatic or manual, by the way.