Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select From ExcelFirstSheet
Message
From
18/05/2010 13:21:29
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italy
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Third party products
Title:
Select From ExcelFirstSheet
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Miscellaneous
Thread ID:
01465038
Message ID:
01465038
Views:
107
I'm trying to extract data form Excel via ODBC.
I can connect like that:
lcStringaConn = "Driver={Microsoft Excel Driver (*.xls)};" ;
           		+ "DriverId=790;" ;
           		+ "Dbq=E:\myDir\myFile.xls;" ;
           		+ "DefaultDir=E:\myDir"
           	
ln = SQLStringConnect(lcStringaConn)
I' can get data with:
? SQLExec(ln, "Select * From ['Sheet1$']")
but the first sheet is often renamed so I've the need to extract data from the first sheet without knowing the name of the sheet.
Something like:
? SQLExec(ln, "Select * From ['Workbook.sheets(1)$']")
Is it possible?
TIA
Bruno
Next
Reply
Map
View

Click here to load this message in the networking platform