Access to FoxPro 1

[Sherry]

How can I Konvert a MSAccess database to a FoxPro Database?<br><br>Any help would be greatly appreciated! <br><br>Sherry

 

[dgrewe]

From Access open your database.<br>Select one table and export it (save as a DBF),&nbsp;&nbsp;or a text file or a delimited file.<br>Do this for each table in your database.<br><br>If you export as a DBF file and are using Fox2.6 or VFP and want all the tables to be free tables, End of conversation you are done.<br><br>If you export as a text or a delimited file you will have to build a table structure in foxpro to import the data into.<br><br>If you are using VFP and you you want Databases instead of Tables, you will have to create a database container and import the tables into it.<br><br>There may be a 3rd way - ODBC - but someone else will have to walk you through that one.<br><br>Which way you go is up to you and the type of data you need to export and want you want to do with it in FoxPro.. <p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br>

 

[foxdev]

(note: I typed all this, then realized this is the FP forum, not the VFP forum, but maybe it will be useful to someone anyway)<br><br>To expound on what David said:<br><br>The alternate way is to create a connection to the Access database using the Connection Designer (or the CREATE CONNECTION command, but let's do this the easy way).&nbsp;&nbsp;You'll have to store the named connection in a DBC, so if you don't have one, create a temporary one for this game (i.e. CREATE DATABASE TEMP ).<br><br>After the connection is created, named and saved, you can create one or more remote views.&nbsp;&nbsp;Issue the command:<br>CREATE SQL VIEW REMOTE<br>then choose your named connection; you'll then get to choose the table(s) from Access (you'll probably make one remote view per table).<br><br>When you open the remote view:<br>USE MYREMOTEVIEW<br>you can then use the COPY TO command.<br><br>FoxDev<br><A HREF="

http://www.foxdev.com"

TARGET="_new">

http://www.foxdev.com</A><br><br>