0

Good Day all,
My question is When I get the schema of an EXCEL worksheet with Column headers I get what's expected the names of the columns but when I get the schema of a worksheet without headers I get the first row of data as the Column Names. The trouble is in determining if a worksheet has headers or not, so as to program my connection string correctly. Anyone have thoughts on this? I created a worksheet with the schema as it is in the dataView.

Thank you
KRod

Edited by kRod

2
Contributors
3
Replies
21
Views
4 Years
Discussion Span
Last Post by kRod
0

I'm not really sure what you're asking here. You wish to check to see if there are headers in an Excel file with VB.NET?

0

Well I have come to the conclusion: Added a CheckBox to the Form for Has or HasNot Column Names, Let user Preview the WorkSheet, set Connection String from that. Kind of ruins any automation though.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.