Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import From Access
Message
 
 
To
08/08/2001 14:16:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00541438
Message ID:
00541463
Views:
10
This message has been marked as a message which has helped to the initial question of the thread.
>Hi Sergey,
> This solution requires Access 2000 or newer, which I do not have. I do have Access97, but I would like to do this directly without Access, if possible.

You can use ODBC. The SQLTABLES() will give you info about tables in MDB. Using SQLEXEC(lnConn, "Select * From Table1", "Mycursor") you can pull data from Table1 in Access into cursor and than use COPY TO Table1 to move it into VFP table.

The SQLCOLUMNS() retrievs info about columns if you would need it.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform