General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to import a VFP parameterized view in Excel
Environment versions
Network:
Windows 2003 Server
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