Solved

Remove Headers in Excel

Posted on 2004-08-06
8
294 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
  • 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

813 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now