![]() WORKAROUND SOLUTION (BTW: "Using Excel 2010") Even more strangly it has successfully done it on one of the. TXT files before and Excel has picked up the table header row without problems but for some reason it is now having trouble on this file. ![]() I've done the same plenty of times with these MYOB. It is treating the MYOB account codes as dates which is causing no end of headaches. On the Import Wizard it is only showing me two columns (which matches the document header information in the equivalent of A1 and B1) so I can't set the third column to "TEXT" instead of "GENERAL". It has some document header information in the first six rows then the table header and the data. I have a related problem and I have discovered a work around solution.
0 Comments
Leave a Reply. |