Microsoft jet database problem

[Vince]

Help

I have a large database in Microsoft Works, and I want to import it into a Microsoft Access Database. I followed the instructions in Access help to conver the file to DbaseIV file and save and then import it by using the help instructions.
Open a database, or switch to the Database window for the open database.


To import files, on the File menu, point to Get External Data, and then click Import.
To link files, on the File menu, point to Get External Data, and then click Link Tables.

In the Import (or Link) dialog box, in the Files Of Type box, select one of the dBASE file types.


Click the arrow to the right of the Look In box, select the drive and folder where the .dbf file is located, and then double-click its icon.
When I follow this I get an error " The Microsoft Jet Database Engine could not find the object " File name" make sure.............path is correct.

What am I doing wrong....can you suggest a solution other than copy and past the entire DB.

Thanks

Vince

 

[jjturner]

I tried the same thing and got the same error. I don't know why this would be offhand.

As a workaround, I saved the Works db as a .csv file. Access allows me to import it in this format (you'll have to look for files of type text files when you're browsing in the Import window once you have your Works db saved as .csv).

HTH,
John

 

[Vince]

Thanks I will try that
Vince

 

[Vince]

Solved the problem, thanks