c++: Microsoft ADO getting table structure information from an excel

  ado, c++, excel

For a Microsoft SQL server would execute the query:

SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = TableName;

Which would work…but if my source is an excel spreadsheet that does not work. The problem being no knowledge of what INFORMATION_SCHEMA or INFORMATION_SCHEMA.COLUMNS is.

So my question is how to get Column Name, Data type, and field length from excel using ADO as my access method?

Source: Windows Questions C++

LEAVE A COMMENT