Hi Bruce,

Thanks for all the input, will followup tomorrow.

Do you have Excel? It can be made to work with an Excel spreadsheet.

Change the connect string to:

mydb.Open(?"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="++strdb++";Extended 
Properties=Excel 8.0")

strdb would be the path to an .xls file

qname can be ?"[Sheet1$]"

The top row labels will be the field names

Its supposed to also work with named ranges, but that doesn't seem to be 
working for me in a quick test.

Also, real numbers don't seem to be working for field values.

Regards,
Sheri

Reply via email to