Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access query to csv truncates on memo field

Status
Not open for further replies.

toolking

MIS
Oct 13, 2003
6
0
0
US
I have been attempting to work at converting MS Access 2K reports to Excel. After reading the numerous postings regarding the difficulty/impossibility of doing this feat, I attempted, for more or less a piece of mind, to convert to CSV. When I did that, it looked a lot better than the excel attempt, BUT, I am still getting a truncation on a memo field at approximately 125 characters.

Is there anyway to fix this cleanly?

Thanks,
 
Hi toolking

Did you try exporting the query that the report is based on to an excel file? just a suggestion. It will export the entire contents of memo fields over 255 characters.

Lu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top