convert dBASE to MS access?

Hi,
I'd like to know how I can convert dBASE databases to MS access databases. There's something in access File -> Migration tools -> importing thing (not sure of the names), though I don't know if they work well, nor if it can't import dBASE. I don't have access installed, it would be for a student job (or vacation job, don't know how it's said in english). Does anyone have any experience with this?

Thanks,
Ludootje

 

Access does a pretty good job of importing dBase data files. Just Open a file, select the dBase version of the files you want to import, select them and they're imported.

 

you can try following
DBF -> Access -> MS Migration Assistant -> SQL Server 2008.

 

Create a blank Access database, and then go to File->Get External Data->Import. This choice will then open up a file browser dialog, where you can choose which type of file you want to import, and where the file exists. So, just choose DBase in the "Files of Type" drop-down, and browse for your .DBF files. Bring them in one at a time, and they will become tables in your Access database. This will not do anything at all to the DBase files; it just reads the data and creates native Access tables in your database.

 

Hi,

First you export data from dbase and import in ms access and check it.

Thanks!

 

No need since Access imports dBase directly. Doing it in Access leads to fewer errors and less lost data.