I am reading an excel sheet into a datareader or dataset and would like all
the columns be system.string. I'm using the following connect string:
Private xlPNSCon1 As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\My Documents\some.xls;" & _
'"Extended Properties=""Excel 8.0; HDR=YES; MaxScanRows=0; IMEX=1"""
Is there any option to make ado read the columns as strings?