How to export ACCESS Long Text data?

Question

I have an Access database that has been around for about 20 years

Recently I changed my DESCRIPTION column in one table to LONG TEXT which took care of an extra long description

When I CSV exported the table to transport the data went from

The data in the column in Access is

PROMO 2024 (20TH ANNIVERSARY) / <LOGO> ON 20 / <STEAMPUNK> 19 / <DRAGON SLAYER> 17 / <WIZARD> 16 / <CHRISTMAS> 15 / <ST PATRICKS> 14 / <VIKING> 12 / <CLOCKWISE DRAGONS> 11 / <CLK STEAMPUNK> 10 / <RUNIC III> 9 / <CELTIC> 8 / <HALLOWEEN> 7 / <BLOODSUCKER> 6 / <DOGS> 5 / <DWARVEN> 4 / <ELVISH> 3 / <CATS> 2 / <JAPANESE III> 1

330 characters

,"PROMO 2024 (20TH ANNIVERSARY) / <LOGO> ON 20 / <STEAMPUNK> 19 / <DRAGON SLAYER> 17 / <WIZARD> 16 / <CHRISMAS> 15 / <ST PATRICKS> 14 / <VIKING> 12 / <CLOCKWISE DRAGONS> 11 / <CLK STEAMPUNK> 10 / <RUNIC III> 9 / <CELTIC> 8 / <HALLOWEEN> 7 / <BLOODSUCKER> 6",

Only 254 characters

I see a lot of posts complaining about this truncation for export to EXCEL ... but none to a flat file

Any suggestions?

Answer 1

If your intent is to export to MySQL, an intermediate CSV file is not necessary. Link the MySQL table using the MySQL ODBC driver, and run an Append query.

Answer 2

I have resolved the export problem .. although I am not sure how I did it ... which bothers me

Now to work on the MySql Import :)

Thanks for the help all

Answer 3

I was able to follow the instructions and reveal the hidden columns ... but there was no Data Type of MEMO only LONG TEXT which is what I am using

Answer 4

I had not seen that before ... looking now

Answer 5

Have you seen this?

https://www.access-programmers.co.uk/forums/threads/how-to-prevent-truncation-of-memo-field-field-255-char-on-export-to-text-file.189988/