I need some help. My application reads an excel file and dumps it into a recordset. The problem is that if a coloumn in excel has numbers and text in it only the numbers are dumped into the recordset and not the text values. The text values are just blank
Set rsCat = New ADODB.Recordset
Set conn = New ADODB.Connection
sqlCatExcel = "select * from [All $]"
rsCat.CursorLocation = adUseClient
rsCat.Open sqlCatExcel, "DRIVER=Microsoft Excel Driver (*.xls);Extended Properties=excel 8.0;" & "DBQ=" & filename
Set DataGrid1.DataSource = rsCat