Forum Discussion

Dmag's avatar
Dmag
Contributing User
6 months ago

Data not exporting to Excel correctly

Hi, I'm using the Import/Export function to export Employee Card data. I've tried using Comma Separated and Tabs as the separate types but I'm still having the same issue.   When the text file i...
Mike_James's avatar
Mike_James
Ultimate Cover User

Hi Dave Dmag , open the text file and scroll down to where it goes haywire.  There's probably a field containing a line break, or quote mark, etc, something that causes a new line. Then see if you can remove that in the file, and repeat the export.

Mike_James's avatar
Mike_James
Ultimate Cover User
6 months ago

PS use the tab delimited format.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.