I have a problem with foxpro 2.6, I have acces the data I need to change through foxpro 2.6. how to import the data mdb to dbf or how do I process the data through foxpro asses. and how to use mdb to foxpro commands such as append, repleace, DELE or other orders please thanks for helping out a full reply

If you need to convert MDB data to a DBF:

http://bit.ly/LH7Gig

If you need to directly update MDB data still inside an MDB, you'll either need the FPW "connectivity kit" which exposes any ODBC data source to FPW or you'll need to learn the long-deprecated DDE commands available to FPW.

thanks for the help, but I do not know how to integrate mdb to dbf program in foxpro 2.6, is there a command or its syntax can I enter in the command line in foxpro prg. please help

Foxpro 2.6 **CANNOT** natively manipulate data stored in Access MDB files. Full stop.

You can either:

* Export MDB data to a dbf (I've shown you a google search for tools to do this)
* Export MDB data to a dbf using Access itself
* (this begs the question why not do the work in Access anyway?)
* Use ODBC to get a remote connection to the Access data

You will NOT be able to use FoxPro commands to manipulate Access data. Even if you get an ODBC connection, you can only send SQL commands to Access to manipulate the data.

Is this clearer?

sorry, can you give examples of command convert mdb to foxpro dbf in the sample command or by using the dos prompt. and can help me sample command mdb sql for data manipulation. thank you

can you give examples of command convert mdb to foxpro dbf

As Dan has explained above you CANNOT simple 'convert' MDB to DBF unless you want to use some 3rd party tool like dbConvert ( http://dbconvert.com/convert-access-to-foxpro-pro.... )

Again, as Dan has explained above, you can use the Foxpro language to Insert/Edit/Delete/View data from directly within an Access MDB database by using one of the methods he has listed.

I guess that I am not 100% clear on whether:
1. You want to COMPLETELY convert an Access MDB database and its data tables into the Foxpro DBF format.
2. Or do you want your Foxpro application to use and/or manipulate data from within the Access Database?

If the former, I'd suggest using either the Access Export utility (As Dan Has Suggested) or one of the 3rd party 'conversion' tools.

If the later, then I'd recommend that you use ODBC to 'connect' your Foxpro application to the Access data.
A Google search for: foxpro odbc access mdb will give you some more detailed advice on this.

Good Luck,
JRB-Bldr

That depends on the converter program you are using. Which one of the many shown in the Google search above have you selected?

What you are asking is like requesting driving directions without saying where you're going.

If you search the internet for "MDB to DBF" (as danfreeman has already shown you) you will find a number of tools to help you to convert a .mdb file. There are no foxpro commands to do it. I don't think you can do it without something that 'understands' JET databases.

I have a program that generates the data mdb at any time. but I want to create a new program for processing such data. and the processing program will be used by the operator. I want to be easy to use, I will install the converter in my foxpro program. so when the operator needs to call the data mdb he lived through foxpro converter menu. and then the data is processed by a foxpro.

how to use mdb to dbf command in dos prompt, please help me ....

I use a program white town wizard ,how do i use it in dos prompt ...

Have you bothered with the vendor's documentation?

White Town's command line reference is here: http://www.whitetown.com/mdb2dbf/cl/

how to use mdb to dbf command in dos prompt

There are NO single FP commands that can do this.

I want to create a new program for processing such data.

If so, then I'd recommend a couple of issues:
1. I would not use a 3rd party data 'conversion' program if you want to process Access data on a regular basis. It would be good for a one-time conversion, but not to run frequently - data may get over-written and/or changed.
2. Write your own data processing application in a more current version of Foxpro - VFP9 instead of the OLD, OLD non-Visual Foxpro
3. Use ODBC to get 'real-time' access to the M$ Access data.

Good Luck,
JRB-Bldr

how to use mdb odbc to access data in FoxPro 2.6 for windows?
how to setting?
and how to manipulate data in foxpro mdb after using odbc?
thank you

Did you read my #2 recommendation above?

If you do not already have a Foxpro application which needs to be modified to now incorporate this utility - great.
Write it in VFP9.

If you DO already have a FP application, I'd recommend first converting it to VFP9 and then add in this new utility.

Once you do that you merely establish a Connection from your VFP9 application to the 'remote' data in the M$ Access data tables.

That can be done in a number of ways
1. Use workstation defined DSN ODBC 'connection' and SQL-Pass Thru commands
2. Use DSN-less 'connection' and SQL-Pass Thru commands
3. Use VFP Remote View

Good Luck,
JRB-Bldr

The others have tried to tell you several times, this is not just a single file conversion, you can do without any interaction and further information. MDB is a database with many tables, views (queries) and even code, not only data.

Quotes from http://www.whitetown.com/mdb2dbf/cl/:
The "if possible" hints this isn't the normal case.

I suggest you rather download the shell and do your conversion interactivley via the UI: http://www.whitetown.com/dbf-converters/

Bye, Olaf.