>I need to automate an importation process from an MSAccess table into a DBF table.
>
>I can open the Access table using the Connection Designer/ Remote View, but the Access Table itself could be located anywhere on the client's system, so I want to give them a user-definable path to it.
>
>Using the Connection Designer, I created a connection to the MSACCESS table in the project manager as "CONNECT1".
>I then created a remote view based on that connection, called "MSACCESS1"
>
>My problem is I don't know how to automate it to 'access' this Access table without bringing up another VFP automatic browse box, looking for the Access table.
>Is the above the best/only way to import from Access (not sure which version).
>
>Ideally I would like to be able to say...
>
>USE MSACCESS1 with "*path+filename of Access table*"
>
>Can I do something like this in VFP6/SP5?
>
>Thanks in advance,
>
> -Kevin.

Instead of using Stored connection use SQLSTRINGCONNECT() and use that connection handler for your views.

lnAccessHandler = SQLSTRINGCONNECT(.....)
USE MyDataBase!MyView CONNSTRING lnAccessHandler

That way you could build the connection string on the fly.