Importing Works database to excel

[Don Strachan]

Hi to all

I am trying to import a works database into excel.

I can convert database to CSV etc buton importing to or opening in
excel the text in each cell is truncated to 256 characters.

If I paste 1 cell from Excel into say Word I only get 256 characters.

I have researched this on the internet but cannot find the answer.

What is is the solution?

I am using Excel from Office 97


Cheers
Don Strachan

For some 10,000 NZ and international Automotive, Alternate Fuel and Motorsport Links and information.

Dons Auto Pages: <http://www.donsautopages.co.nz/>
Email: <[email protected]>

 

[Guest]

Don,

Try saving it as a good old dBase IV file and then open a dBase file.

This knowledge base article addresses the requirement.:

http://support.microsoft.com/kb/163108