>How do I extract records from an ACCESS file (.MDB) in VFP6? I've setup a local system DSN to the table in question and can SQLCONNECT to it ok, but SQLTABLES shows nothing, and a SQLEXEC(SqlHandle,"SELECT * FROM MYTABLE") results in an error telling me the filename is not found. But, of course, the filename is correct - I've even tried complete path and extension.
>
>Is there any way to "open" the ACCESS file directly from VFP? Or, what am I doing wrong with the ODBC connection?
>
>I do not have ACCESS so I can't just export from there... Any help appreciated.
>
>-Arne

Arne

Check Microsoft Knowledge Base article --> Q260405