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#"

---

UDI Magic Tutorials - Excel to Tally

Topic: Import UNIT Master data from Excel into Tally Software

This tutorial covers how to use UDIMagic utility to import UNIT Master records from MS-Excel into Tally Accounting Software.

Visit UDIMagic tutorials page at our site.

SQL Server to Tally Software

Tally Integration made Easy

New Release 1.3
udi-Magic v3.0 Release 1.3 [Professional] allows you to transfer data directly from MS SQL Server to Tally Accounting Software using few SQL-SELECT statements and XML tags.

Supports all versions of Microsoft SQL Server.

Click here for more details on MS SQL Server to Tally

XBase (DBF) to Tally Software

Tally Integration made Easy

New Release 1.2
udi-Magic v3.0 Release 1.2 [Professional] allows you to transfer data directly from XBase (DBF) files to Tally Accounting Software using few SQL-SELECT statements and XML tags.

Supports
a) DBase
b) Fox 2.x
c) Visual Foxpro DBFs and DBC files
d) Other XBase file formats.

Click here for more details on XBase (DBF) to Tally

Introducing udi-Magic v3.0 Professional version

Tally Integration made Easy

udi-Magic v3.0 Professional allows you to retrieve data from External databases and send it directly to Tally Software.

Useful for Software Developers
udi-Magic professional is particularly useful for Software Developers / programmers who wish to INTEGRATE their software with Tally Accounting Software. Instead of modifying the existing program code, Developers can integrate with Tally by merely writing few SQL-SELECT and XML tags.

Useful for End-Users
Users (i.e. end-users) who wish to Integrate software with Tally but do not have the source-code of the program can do it using udi-Magic professional. Full support is provided by for writing SQL-SELECT statements and XML tags for Tally Integration.

In the coming days/weeks, support for additional databases shall be included in the udiMagic professional version.

Introducing udiMagic v3.0

UDI-Magic in now available in two versions viz.

UDI-Magic v3.0 [Standard]
Supports transfer of data from Excel to Tally and vice versa. (i.e. push and pull Tally data from/to MS-Excel).

UDI-Magic v3.0 [Professional]
Supports transfer of data from external databases to Tally viz.

• MySQL to Tally
  
• MS-Access to Tally
  

The professional version is a superset of the standard version and includes all the features of the standard version.

Other new features in udiMagic version 3.0

• Using separate file for XML tags
• Using VBA macros with udi-Magic