You can use MS Works to open the database and SAVE AS "Text and commas" (I think that's what Works calls a CSV file).

Then use Access to "Get External Data" and import the data into an Access database. This will bring overtrhe data, but not any input forms that may have been defined in the Works database.

Guy

>.wdb files. Access won't open them. MS Help says to open in works and save as access
>
>Larry
>
>>What kind of MS works files: .wps, .wks, ...? And convert to what?
>>If you are talking about .wks files, then you could use Office Automation to open them via excel and save or convert as needed.
>>
>>>I know that this isn't a FoxPro question, but since I'm the "Computer Guy" at this client site I've been asked to solve a problem converting MS Works. I was hoping that someone has run into this situation somewhere and can offer a solution. I have looked through Microsoft's web site with no luck.
>>>
>>>This client used an old version of MS Works and created hundreds of files to control AR/AP/PR. They have since moved into accounting software, but still use the old files as backup.
>>>
>>>They have upgraded to NT 2000 and MS Office 2000. The MS Works is on an old Packard Bell that was the original computer.
>>>
>>>As you know, Access can not open a MS Works file. The file must be opened in MS Works and then saved in Access format. This will take days to do. I've been looking for a conversion utility that would do this automatically. Seems to me someone may have written something for this.
>>>
>>>Again, I apoligize for posting a non FoxPro question on this site, but I've run out of places to look.
>>>
>>>Any suggestions would be GREATLY appreciated.
>>>
>>>Thanks,
>>>Larry Morelli