Use remote views.
create a fox database (create data mydata)
create a connection to the access database (create connection myconn)
use sqltables() command to get a list of all the access tables
(two steps, x=sqlconn(myconn), =sqltables(x))
then write a program to loop thru the tables and create the views
(like this:
scan
mtable = table_name
create sql view &mtable remote connection myconn as select * from &mtable
endscan
You may have to play around with update properties and stuff using dbsetprop, dbgetprop, and so forth.
Good luck!
>With ODBC, I can open Access and import a VFP database in a couple of easy steps, and maintain long table and field names - I can't find a way to do the reverse.
>
>I have a state database consiting of over 250 tables that needs to be imported and converted each month. Currently the VFP-to-Access method works great, but there are plans to start sending out the data in Access format, and all my reports and data management stuff are in Fox.
>
>Any suggestions?
--Todd Sherman
-Wake Up! Smell the Coffee!