Wednesday, January 30, 2008

Ole Error 800A03EC

FAQs: Excel to Tally

"I am using udi-Magic to import Vouchers from Excel into Tally 9. While importing the data, udi-Magic shows an error message "Ole Error 800A03EC".

Solution:-
It is likely that you are using a FORMULA in the XML tags which is incorrect. In case if you are using several FORMULA's then you must test-check each FORMULA. This can be done by tying out the Formula directly in the MS-EXCEL sheet itself.

For Example, if the XML tags have a Formula as shown underneath:-
FORMULA="=F# & "/" & O#"
You can test-check the above formula in EXCEL as given underneath:-

In the Excel sheet, enter the formula given underneath in any cell (say cell Z2).
=F2 & "/" & O2

You need to test-check each FORMULA that is used in your XML tags. If you get error message while testing the Formula in EXCEL, it means that Formula is incorrect.

Remarks:-
In XML, there are certain characters which have special meaning and are called ESCAPE SEQUENCES. You can get more information about Escape Sequences from this link:-

XML Escape sequences

In simple words, a formula used in Excel sheet is to be changed when used in XML tags as given underneath:-

Excel sheet formula:-
=F2 & "/" & O2

XML tags formula :-
FORMULA="=F# & "/" & O#"


No comments: