# Keeping line breaks in fields in a BAQ Export **Category:** [Vista/Vantage 8](https://www.epiusers.help/c/vantage-8/8) **Created:** 2016-10-07 20:34 UTC **Views:** 1001 **Replies:** 3 **URL:** https://www.epiusers.help/t/keeping-line-breaks-in-fields-in-a-baq-export/35745 --- ## Post #1 by @ckrusen I made a BAQ to export the Parts in V8 that will be uploaded into E10 (via DMT), but the CSV formatted BAQ export loses line breaks in a filed. Particularly in the Description field. How can I move data from V8 to E10, and maintain line breaks in a fields? I can do an ODBC query in Excel, and then open that excel file with DMT and the line breaks are maintained. BUT, some of the Description values are too long for the ODBC and/or Excel. So the ODBC -> DMT works in theory, but not for really long fields. Any suggestions? Calvin --- ## Post #2 by @bordway I believe if you can maintain both the breaks and field sizes via ODBC if you use Access for the initial dump instead of Excel. In the past I've had to specify the format in my Access queries for some fields when dumping to CSV. And when I use a CSV instead of an Excel file for my DMT uploads. I've learned to pay attention when I have those files open in the DMT. Depending on what steps you follow, the DMT can change the format of fields in the CSV. --- ## Post #3 by @ckrusen Thanks. But it turns out that several of the Part's descriptions exceed the fields definition, and this causes ODBC connections to fail. Maybe I'll take a look at how an XML formatted BAQ Export looks, and then figure out how to get an XML file into Excel. Calvin --- ## Post #4 by @jdtrent Just a thought. You could do a replace to another character in the query, and then search/replace it back in Excel. Joe --- **Canonical:** https://www.epiusers.help/t/keeping-line-breaks-in-fields-in-a-baq-export/35745 **Original content:** https://www.epiusers.help/t/keeping-line-breaks-in-fields-in-a-baq-export/35745