Import MS Works database to Access 2007

  • Thread starter Thread starter JerryMears
  • Start date Start date
J

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
 
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.
 
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/
__________________________________________
 
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)


Richard said:
Tom Wickerath said:
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/
__________________________________________
Click to expand...


Works databases can be saved as:

Text & Commas [*.csv]
Text & Tab
[*.txt]
dBASE IV
[*.dbf]
dBASE III
[*.dbf]
Richard
Click to expand...
 
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).
Click to expand...

It may depend on the specifics of the wdb, but I have succeeded in importing a
wdb into Excel (and thence into Access).
 
JerryMears said:
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
Click to expand...
 
Back
Top