dbf to MDB

[zxcdf5je]

Hi all:
I am trying this some days now and dont know wht to do since i am not getting any results.
I want to convert dfb files to MDB with the FPT Memo information being transferred to at the same time.
I tried using softwares like DBF manager and DBF2MDB.
These softwares gives me the solution i want but they noly allow you to transfer 25 records since I have downloaded the trial version and dont want to buy the softwares.

I have 10,000 records which needs to be transferred and 5 such tables.I wanted to know if there is any other way i can do it without buying the softwares?
Please do let me know.

 

[BillPSU]

First, a .dbf file will transfer into a table within an .mdb.

Second, what is the source of the .dbf is it dBase or VFP or another xBase? A dBase file can be linked or imported. A VFP file must be linked but I am not sure with what as I have never done that.

 

[ZoDra]

Hi zxcdf5je,

If you have MS Access it is easy: File->Get external data-> Import. First you have to open NEW ACCESS DATABASE and save it. If you choose Link instead of import MDB database will establish a link to DBF file, while Import will create a NEW TABLE in MDB DATABASE. The table will have same name as DBASE DBF file and will have ALL data.

 

[1oldfoxman]

If the above idea doesn't pan out, you could extract the .dbf file using dBase so you could control the output to include the memo fields (if you have it dBase) to a comma delimited file and then import into Access.