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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
? Convert Dbf to MDB 1
- Thread starter sigma123
- Start date
Mike Gagnon
Programmer
sigma123
Does anyone knows how can i convert a DBF file (VFP) to MDB Format (Access) and viceversa.
You might be mixing things up, since a DBF file is a Table, and an MDB is a database (a container that contains tables). Not the same thing.
Mike Gagnon
If you want to get the best response to a question, please check out FAQ184-2483 first.
Does anyone knows how can i convert a DBF file (VFP) to MDB Format (Access) and viceversa.
You might be mixing things up, since a DBF file is a Table, and an MDB is a database (a container that contains tables). Not the same thing.
Mike Gagnon
If you want to get the best response to a question, please check out FAQ184-2483 first.
Hi!
Be aware of the fact that some fields are slightly different in VFP and ACCESS.
I remember I once tried to import an ACCESS file into VFP and found that there is a slihght problem. I think the ACCESS field holds 255 characters (maybe 254 or 256 ? don't remember exactly).
-Bart
Be aware of the fact that some fields are slightly different in VFP and ACCESS.
I remember I once tried to import an ACCESS file into VFP and found that there is a slihght problem. I think the ACCESS field holds 255 characters (maybe 254 or 256 ? don't remember exactly).
-Bart
Mike Gagnon
Programmer
sigma123
Why not create a blank database in Access and import the tables in to the MDB with the Get external Data function.
Mike Gagnon
If you want to get the best response to a question, please check out FAQ184-2483 first.
Why not create a blank database in Access and import the tables in to the MDB with the Get external Data function.
Mike Gagnon
If you want to get the best response to a question, please check out FAQ184-2483 first.
It sounds like you want to automate Access. There are a lot of example of automating Excel and Word in this forum, but I don't recall seeing may with Access.
I have limited experience using VB within Access, but I can tell you that the syntax is a bit different from Excel/Word.
You may find thread184-525594 helpful.
Brian
I have limited experience using VB within Access, but I can tell you that the syntax is a bit different from Excel/Word.
You may find thread184-525594 helpful.
Brian
alvechurchdata
Programmer
Talking to Access is always more difficult than need be because some versions of Access can't cope with some versions of VFP. I find it better to use ADO from within Fox and create an MDB without caling on Access at all.
Geoff Franklin
Geoff Franklin
-
1
- #8
On the Universal Thread
There are MDB2DBC and DBC2MDB routines to convert Database container contents.
Search for those names in the Summary field of the Search Engine.
HOWEVER - They may or may not work due to many of the issues listed above.
I know that I have not gotten a completely successful "conversion" using them. Partial success - yes, but full success - no. But, who knows, maybe you will.
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
There are MDB2DBC and DBC2MDB routines to convert Database container contents.
Search for those names in the Summary field of the Search Engine.
HOWEVER - They may or may not work due to many of the issues listed above.
I know that I have not gotten a completely successful "conversion" using them. Partial success - yes, but full success - no. But, who knows, maybe you will.
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
- Status
Similar threads
- Locked
- Question
