 |
ASP.NET 1.x and 2.0 Application Design Application design with ASP.NET 1.0, 1.1, and 2.0. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the ASP.NET 1.x and 2.0 Application Design section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|

April 12th, 2004, 03:07 PM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
Excel Data Import
Hello,
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
Header
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.
Thanks,
Brian
__________________
Brian
|

April 14th, 2004, 10:54 AM
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
Are you using SQLServer DTS to import this. In your case, that would be the easiest way.
|

April 14th, 2004, 11:38 AM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
I'm planning on using ADO.NET or DTS, however, the data's unformatted, and was wondering if anybody had a way to format this, other than manually.
|

April 14th, 2004, 12:15 PM
|
Friend of Wrox
|
|
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
|
|
You can easily set up a DTS and not have to worry about formatting. When you set up the Transform Data Task, on the Options tab, you can specify what row to start pulling the information from. Accoring to your sample layout, it looks like it will be row 4. Let me know if this helps or you need more info.
|

April 14th, 2004, 02:12 PM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
Yeah, though I need the header imported also, plus there is breaks between each section also, where there are 3-4 blank rows between section. Although I could go in and delete these with no problem...
I just need the header on the same row, and possibly other information too that might be at that level.
Thanks for your help.
|
|
 |