Reading excel sheet into a recordset

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 456,233 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,767 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums

Thread Tools Display Modes

Views: 1611 | Replies: 1

•

Join Date: Oct 2007

Posts: 10

Reputation: Pareshja is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

Pareshja

Offline

Newbie Poster

Reading excel sheet into a recordset

Nov 8th, 2007

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