Hello,
I building an automatic parser in .NET that opens an XLS using OLEDB's Jet driver. In the connection string it allows you to add "HDR=Yes" as an extended property if the first line has the column titles instead of the data (so the OLEDB will skip the first line). This is a great option, but how does one determine whether the first line should be skipped or not at run time? With a CSV file it is possible to just open the file as text, read the first line, and look at it (i.e. to find if it contains "Zip Code" and "Phone") to determine whether to tell OLEDB to skip it. But this doesn't work with XLS. Any suggestions would be appreciated!