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
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++