Workshhet name

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top