Hi-
I have a table that I need to distribute to people who do not have MS Access, so I am exporting it as a comma-delimited text file. Pretty straightforward, EXCEPT for the fact that one of the fields is of type MEMO. There are numerous records that have carraige returns in that MEMO field --- but they look like wet elephant turds when you export them the text file (ie. the carraige return is exported too, which breaks up the text in that memo field so that it dribbles all over the page, breaking with every CR, causing the records to not be read properly into MS Excel, for example.)
Anyone have thoughts on a solution?? I was imagining some code that, on export, searched through this memo field, replacing all vbCR with something like " - "; wouldn't necessarily look pretty but that's fine, as long as all the text is there and it reads properly into Excel (or wherever one might want to read it).
Thanks in advance,
Andy
I have a table that I need to distribute to people who do not have MS Access, so I am exporting it as a comma-delimited text file. Pretty straightforward, EXCEPT for the fact that one of the fields is of type MEMO. There are numerous records that have carraige returns in that MEMO field --- but they look like wet elephant turds when you export them the text file (ie. the carraige return is exported too, which breaks up the text in that memo field so that it dribbles all over the page, breaking with every CR, causing the records to not be read properly into MS Excel, for example.)
Anyone have thoughts on a solution?? I was imagining some code that, on export, searched through this memo field, replacing all vbCR with something like " - "; wouldn't necessarily look pretty but that's fine, as long as all the text is there and it reads properly into Excel (or wherever one might want to read it).
Thanks in advance,
Andy