Prev: error bulid in cavo27b new FabOutlookBarLib
Next: How to get longer fields than 255 chars with SqlConnection
From: John Martens on 13 Jul 2008 09:51
I'm using SqlConnection to read (just read) data from an excell file.

I open like this:

oHost := SQLConnection{}
lConnect := oHost:DriverConnect(,
SQL_DRIVER_COMPLETE_REQUIRED,"Driver=Microsoft Excel Driver (*.xls) ;
Dbq="+cFileNm)

How do I get the sheetnames of the file ?

If I do not know them it's hard to get the data using
"SELECT * FROM [sheet1$]"

John
 | 
Pages: 1
Prev: error bulid in cavo27b new FabOutlookBarLib
Next: How to get longer fields than 255 chars with SqlConnection