General information
Title:
Is it possible to import a VFP parameterized view into Excel
Environment versions
Microsoft Office:
Office 2010
Is it possible to import a VFP parameterized view into Excel?
I am using Excel 2010. Data tab > From Other Sources > From Data Connection Wizard > Other > OLE DB driver for VFP > select my VFP DBC.
Test connection succeeds
Data connection wizard them prompts me to select a table: I can select a parameterized view that I already created in my VFP DB. And then finish.
Where do I want to put the data? =$A$1. Then the error: SQL: Column 'NPROJECTID' is not found. Where, nProjectID is the parameter variable. VFP would normally prompt for a value. Excel does not.
What is the best way to do such an import of a VFP parameterized view into EXCEL?
Thanks,
Jim
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only