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
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
urgent import / append mdb to dbf 3
- Thread starter jezky82
- Start date
Dan Freeman
Programmer
If you need to convert MDB data to a DBF:
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.
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.
- Thread starter
- #3
Dan Freeman
Programmer
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?
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?
- Thread starter
- #5
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 ( )
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
As Dan has explained above you CANNOT simple 'convert' MDB to DBF unless you want to use some 3rd party tool like dbConvert ( )
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
Dan Freeman
Programmer
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.
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.
- Thread starter
- #9
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.
- Thread starter
- #10
- Thread starter
- #11
-
1
- #12
Dan Freeman
Programmer
Have you bothered with the vendor's documentation?
White Town's command line reference is here:
White Town's command line reference is here:
-
1
- #13
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
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
- Thread starter
- #14
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
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
-
1
- #16
Olaf Doschke
Programmer
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
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:
Bye, Olaf.
Quotes from
Code:
/BATCH ... Batch mode. The program does not ask any questions (if possible).I suggest you rather download the shell and do your conversion interactivley via the UI:
Bye, Olaf.
- Status
Similar threads
