Could someone tell me if it is possible to get the length of a field
retrieved with the sqldatareader

I think the best way to execute the get schema query by giving th table name
to the Command object with Data Adapter. After getting the Data table you can
get the column details from Data Table

Show quoteHide quote

DataSet to Access Database
Datarelation handling
Dataset with large tables
User Controls and ADO Connections
Retrieving Excel Schema Information