M
Marc
lcConnectionToOpenedXls = "Driver={Microsoft Excel Driver (*.xls)};
DriverId=790; Dbq="+<ExcelTemplateFilename>+";
DefaultDir="+JUSTPATH(<ExcelTemplateFilename>)
lnHandleToOpenedXls = SQLSTRINGCONNECT(<lcConnectionToOpenedXls>)
SQLTABLES(lnHandleToOpenedXls,"","fWorkSheetAlias")
SQLDISCONNECT(lnHandleToOpenedXls)
I use this VFP coding to retrieve worksheet information from the excel file.
If a worksheet name contains a dot(.) it shows as # after retrieving data.
What is the reason for this?
What are the other characters represents in # marks after retrieving except
of the (.)
If I have two work sheets like (Sample .#), (Sample ##), how do I
differentiate those?
DriverId=790; Dbq="+<ExcelTemplateFilename>+";
DefaultDir="+JUSTPATH(<ExcelTemplateFilename>)
lnHandleToOpenedXls = SQLSTRINGCONNECT(<lcConnectionToOpenedXls>)
SQLTABLES(lnHandleToOpenedXls,"","fWorkSheetAlias")
SQLDISCONNECT(lnHandleToOpenedXls)
I use this VFP coding to retrieve worksheet information from the excel file.
If a worksheet name contains a dot(.) it shows as # after retrieving data.
What is the reason for this?
What are the other characters represents in # marks after retrieving except
of the (.)
If I have two work sheets like (Sample .#), (Sample ##), how do I
differentiate those?