Solved

Remove Headers in Excel

Posted on 2004-08-06
8
296 Views
Last Modified: 2010-04-23
Hi everyone:

How to remove headers (total 11 fileds) from Excel through VB.NET code before dumping data into SQL table.

RGDS
Sam
0
Comment
Question by:BOOBIC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 11739280
I think this is what you mean.


In the connection string:

Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"

HDR=Yes; indicates that the first row contains columnnames, not data
IMEX=1; tells the driver to always read "intermixed" data columns as text

Bob
0
 

Author Comment

by:BOOBIC
ID: 11739477
Yes, that's what you have in connection string and only one line of header. But in my case I have 11 lines of headers describing name of the file, date of creation, company name, ....I have to remove them all in order to dump data into SQL.

RGDS
Sam
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 11739533
How are you "dumping" to SQL?

Bob
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:BOOBIC
ID: 11739702
I didn't wrote any code yet.

Sam

0
 
LVL 4

Accepted Solution

by:
Jigit earned 100 total points
ID: 11745769
1. Save the Excel file as CSV ( worksheet.SaveAs() ) - comma separated text file
2. Open the CSV file programmatically for reading
3. Ignore header lines and then start dumping into SQL

HTH,
Jigit
0
 

Author Comment

by:BOOBIC
ID: 11776752
Hi Jigit:

Thank you for you message. This one of the methods to use. In my app, I have to do it on Proccess_Click event (one click). I got the solution for that.

Thank you.

Sam  
0
 
LVL 4

Expert Comment

by:Jigit
ID: 11824444
BOOBIC, thank you for accepting my answer and grading it A. Would you like to fill some feedback?

Thanks,
Jigit
0
 

Author Comment

by:BOOBIC
ID: 11825993
I dumped data into SQL and used Delete statement for the rows i would like to be removed.  This not that sofisticated but it does the trick. I needed to move quick with that project. And my question is opened in any way. How to do that right.

RGDS
Sam
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question