ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TXT file importing to other software (https://www.excelbanter.com/excel-discussion-misc-queries/161521-txt-file-importing-other-software.html)

RobN[_3_]

TXT file importing to other software
 
I used to create text files for importing data into another program (MYOB)
without any problems, using Vs 2002.
It seems (although I can't prove the exact time) that problems started when
I upgraded to Vs2007.
Now, using Vs2007, when I use the same Excel workbook and create the
Tab-delimited txt file from Excel and import that into the other program, I
get problems.
eg some fields are treated as -'ve when they should be +'ve, (although that
doesn't really explain the problem).

When I export the data to a text file from the other (MYOB) program and
import it straight back, there are no problems.
However, if I open that same text file in Excel 2007, and then save it as a
text file again (without making any changes!), the problems occur.
(When I save as a text file from Excel it warns about incompatable features,
etc., which is to be expected, and I choose Yes.)

Rob




All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com