dbase file conversion

[Sam C]

I have a number of dbase 3+ files. Can I convert them to access and be able
to add/update the files? What about going from dbase 3+ to Excell to Access?
Can I add/edit then? Should I just stick with a dbase program like Approach?

Thanks,
Sam Ciocco

 

[John Nurick]

Hi Sam,

Access can link to dbf files and use them almost as if they were tables
inside an mdb file. Use the "File|External Data|Link" menu command. Or
if you don't need to share the data with an xBase application, import
the data instead.

That's the data. Database functionality - screens, reports, programming,
etc. - can't be imported: you'll have to re-create that using Access's
own tools.


On Sun, 19 Feb 2006 16:20:26 -0800, "Sam C" <Sam

 

[Dave H.]

John,
I have tried that, but have received the folowing error message:

The Microsoft Jet database engine could not find the object 'filename'.
Make sure the object exists and that you spell its name and path name
correctly.

I have looked online, and found that I may need additional dBASE ISAM
drivers in order to perform the task. I've tried updating my Jet database
engine and could not install due to a newer version being installed.
Microsoft support was no help. Any help would be much appreciated.
Thanks,
Dave H.

 

[John Nurick]

Dave,

Make sure that the DBF files all have old-fashioned 8.3 names, and that
the folders they're in also have short names, e.g.
C:\Dir\SubDir\file99.dbf
and not
C:\Documents and Settings\User Name\My Documents\Folder\Sub
Folder\file99.dbf

 

[Dave H.]

Thanks John. Worked pefectly.
D

Dave,

Make sure that the DBF files all have old-fashioned 8.3 names, and that
the folders they're in also have short names, e.g.
C:\Dir\SubDir\file99.dbf
and not
C:\Documents and Settings\User Name\My Documents\Folder\Sub
Folder\file99.dbf