Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Preserving Long field data into text output

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-05 : 22:29:50
Randy writes "I would like to spool a sql query into a text file, then import it into MS Excel.
My problem is that I have several fields in my database that are Long fields and they may have multiline data. Ideally, I would like to see the multiline data in an Excel cell, with the multiple lines preserved.

Any suggestions?

Thanks!"
   

- Advertisement -