We are converting an application from MS Access to a web based system. Part of the process is to offload several tables from the Access system to a local PC, then save them as tab delimited files & upload to the web system. A custom program loads the tab delimited file into the web (MySQL) database.
One such table is the customer table. There are a number of cases where saving the Excel as tab delimited creates strange results. See the attached for an example. Note the Excel sample has 19 rows, the tab sample 20. Note row 10 in the Excel sample gets converted into two rows in the tab delimited saved file.
Why does this happen? I'm guessing there MIGHT be tab characters in one or more of the longer text columns, for example, like columns X, Y, AB & AC.