Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I create an ACCESS table from a FOXPRO table?
Message
From
06/04/2000 14:43:07
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
06/04/2000 14:37:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00356151
Message ID:
00356436
Views:
12
>>>Thank you very much! Could you please tell me more about ADO?? I want to create an ACCESS table programmaticly without using ACCESS at all.
>>>
>>>Thanks in advance
>>>
>>>P.S. Sorry for my bad english... :(
>>
>>

FYI Access97 and up is not limited to fox2x for importing. Access97 can import but not link VFP tables.
>>To start learning ADO read "ADO Jumpstart for Visual Foxpro Developers" by JVP on online help.
>>Cetin
>
>Access 97 can link to a VFP free table directory using a system ODBC DSN, I just tested this.
>
>You're right about the importing, it's not limited to fox2x tables.


As I said I didn't test both :) It should be possible with free tables. It's in MSDN documentation as is :
"You can use data from DBF files in FoxPro 2.x format and from DBC files in FoxPro 3.0 format. If you need to leave your data in FoxPro 2.0, 2.5, 2.6 DBF format so that FoxPro users can continue to use it, you can link the data to your Access database. By using Access, you can view and edit the data in linked tables even if others are using it in FoxPro.

If you have no need to maintain your FoxPro 2.x DBF data in its original format or if you are using data from DBC files in FoxPro 3.0 format, you can import these files into Access. You cannot link DBC files in FoxPro 3.0 format."
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform