Exporting/Importing Data

[Guest]

I am posting this again both here and in the Access forum in the hope that
someone can solve my problem.

I have a database query written in Access97 which I export to Excel97.
When it is just saved as a spreadsheet, all the data is imported into Excel.
However, wheh I save it as FORMATTED, it chops off half of the data in some
cells.

Is there a reason for this or a setting in Excel? I cannot find any useful
information on the exporting of formatted data.

Please help!

 

[MattShoreson]

try using data>Import External Data>New Database Query

then link to the query in the access db.

Should eliminate the problem steps you are experiencing.