Member Avatar for Pareshja

Hi Guys,

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


Please help

  • 2 Contributors
  • 1 Reply
  • 126 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by binoj_daniel
Member Avatar for binoj_daniel

Please check the column format of that excel file. Set it to text.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.