Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Working with Access Tables
Message
From
04/03/2002 16:04:49
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00628036
Message ID:
00628046
Views:
19
Mark,

Any ODBC or OleDB tutorial would probably be helpful as well as any information on connecting to SQL Server. The task is largely the same. There is also a file in the downloads section here for moving from dbc2mdb and mdb2dbc. That may be a help. John Koziol is the author of the software.

Hope this helps.

>I have a client who can only accept data in an Access table. I only use VFP. I need to be able to automate a VFP app to do the following:
>
>1. Connect to an Access Table via a remote view
>2. Delete all of the records in the Access table
>3. Add new records to the empty access table from a FoxTable that is identical to the view.
>
>I have staggered through building a form to do this and it is working poorly. Can anyone point me in a direction of a tutorial that will help me with this? I have checked older threads and knowledge base articles and have not found what I am looking for.
>
>Thanks, Mark
Brian McCord
President
Sagacity Systems
Previous
Reply
Map
View

Click here to load this message in the networking platform