Import MS Works database to Access 2007

[JerryMears]

I have a MS Works database file that I wish to convert to Access 2007.
Microsoft seems to make such a simple task imposible. Any suggestions as to
how to accomplish this? I no longer have Works on my system; it was on an
older one that crashed and I lost all the info on the drives.

Thanks for any good ideas or tips!

Jerry

 

[Douglas J. Steele]

Unfortunately, no version of Access has ever been able to import Works. Try
importing the Works data into Excel, and then importing the Excel
spreadsheet into Access.

 

[Tom Wickerath]

Hi Jerry,

You'll need to either reload MS Works on your current system, or find
another computer that has MS Works installed. Then export the data to a text
file. You can import the data from a text file into Access.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Tom Wickerath]

Ah, I didn't realize that Excel could import Works data directly. Good to know.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Richard]

Ah, I didn't realize that Excel could import Works data directly. Good to know.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

Works databases can be saved as:

Text & Commas [*.csv]
Text & Tab [*.txt]
dBASE IV [*.dbf]
dBASE III [*.dbf]
Richard

 

[Tom Wickerath]

Hi Richard,

That's also good to know. In this case, the OP did not have Works installed
on his new computer.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[david]

I don't think so. Works can save Spreadsheets as wks,
(import to Excel), Documents as wps (import to Word),
Databases as wdb (no import filter available).

Works is cheap ~$40, or you can use a demo or free
convertor:

http://www.mydigitallife.info/2008/...-wdb-to-csv-or-excel-without-works-installed/

WDB may be an OLE structured document: it would
be interesting to look at it with an OLE viewer.

(david)

Ah, I didn't realize that Excel could import Works data directly. Good to
know.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

Works databases can be saved as:

Text & Commas [*.csv]
Text & Tab
[*.txt]
dBASE IV
[*.dbf]
dBASE III
[*.dbf]
Richard

 

[John W. Vinson]

I don't think so. Works can save Spreadsheets as wks,
(import to Excel), Documents as wps (import to Word),
Databases as wdb (no import filter available).

It may depend on the specifics of the wdb, but I have succeeded in importing a
wdb into Excel (and thence into Access).

 

[xiaozhou]

I have a MS Works database file that I wish to convert to Access 2007.
Microsoft seems to make such a simple task imposible. Any suggestions as
to
how to accomplish this? I no longer have Works on my system; it was on an
older one that crashed and I lost all the info on the drives.

Thanks for any good ideas or tips!

Jerry