Wednesday, December 5, 2001 10:13 AM
indicates that the first row should be column headings as you noticed. The indication may be that you will have to fetch this first row by using the ResultSetMetadata Object which should be contain column names and types, you would know of course that this information is data and not identifiers. It would pay in the long run to have the format of Worksheets altered to indlcude column identifiers if this process your are creating is to be reused on a regular basis
You might consider reviewing the results returned by a search for the String "Excel ODBC" in this forum which will lead you to several recent discussions on this topic matter. Some also include code snipplets , examples, and other valuable insights.