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.