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.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"JerryMears" <JerryMears@discussions.microsoft.com> wrote in message 
news:1133E821-8183-4DBA-96FF-D66F89580DAA@microsoft.com...
>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 

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

"JerryMears" wrote:

> 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

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

"Douglas J. Steele" wrote:

> 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.
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)

"Tom Wickerath" wrote:

> 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/
> __________________________________________
> 
> "Douglas J. Steele" wrote:
> 
> > 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.
> > 
> > -- 
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)


Works databases can be saved as:

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

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

"Richard" wrote:

> Works databases can be saved as:
> 
>                                                    Text & Commas [*.csv]
>                                                    Text & Tab        [*.txt] 
>                                                     dBASE IV          [*.dbf]
>                                                     dBASE III          [*.dbf]
> Richard

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/12/10/convert-microsoft-works-database-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" <Richard@discussions.microsoft.com> wrote in message 
news:BF9A9C46-EDFB-48A4-AB25-B2716165606C@microsoft.com...
>
>
> "Tom Wickerath" wrote:
>
>> 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/
>> __________________________________________
>>
>> "Douglas J. Steele" wrote:
>>
>> > 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.
>> >
>> > -- 
>> > Doug Steele, Microsoft Access MVP
>> > http://I.Am/DougSteele
>> > (no private e-mails, please)
>
>
> Works databases can be saved as:
>
>                                                   Text & Commas [*.csv]
>                                                   Text & Tab 
> [*.txt]
>                                                    dBASE IV 
> [*.dbf]
>                                                    dBASE III 
> [*.dbf]
> Richard
>
> 

On Thu, 31 Dec 2009 13:09:36 +1100, "david" <david@nospam.au> wrote:

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

             John W. Vinson [MVP]

"JerryMears" <JerryMears@discussions.microsoft.com> д����Ϣ����:1133E821-8183-4DBA-96FF-D66F89580DAA@microsoft.com...
>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