Solved

Remove Headers in Excel

Posted on 2004-08-06
8
295 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
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
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 …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

821 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