You should be able to open it with the ODBC driver, no need for Access.Application. Check out the code from Borislav which is along the same lines as what you had started.

>Hi again,
>
>Using the suggestions provided by both you and Borislav, I was able to get close to opening the table. Previous attempts failed because the file name does indeed contain blanks and I was not using any quotes or brackets when passing the name to the sqlexec statement.
>
>I am able to open the table from within Access itself. I am attempting to automate the retrieval of the table into VFP in order to avoid the extra steps of opening Access and exporting the file only to have to open VFP in order to use it. And since the end user of this program is really not technically inclined, automation is required.
>
>Per your suggestion, I will get in touch with my client services department to see if they can secure the password or better yet, have the client submit the data without one.
>
>I have also attempted to get to this table via a CREATEOBJECT("ACCESS.APPLICATION"). I have gotten as far as opening the recordset, but that leads to having to process each field in the record with a FOR EACH loop for each of the records in the set. This seems like a long way to go to achieve what should be a fairly straightforward export.
>
>Any ideas along this tract?
>
>Thanks again for your time and patience.
>Vince