General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Export VFP to Excel, etc. through ODBC?
Is there any way to call a procedure in an SQL statement that would execute the COPY TO command (for Excel, text, etc. output) from the VFP ODBC driver (not from VFP)? The command is listed as supported in the driver help file, but every time I call a procedure or a .prg with the COPY TO command in it, I keep getting a "Feature not Available" error from the driver.
Has anyone had success doing this, and, if so, how did you make it work?
Environment:
VFP ODBC Driver 6.00.816700
Dell 4350, IIS 4.0, CF 4.0.1
SQL called from ASP or ColdFusion pages.
TIA,
Phil Hegedusich
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