xls n Mdb
RM600.00
Excel (XLS) & MDB Data Import/Export in SQL Accounting Software allows easy transfer of data between Excel, Access, and the accounting system for faster and more accurate data management. Whether you are setting up SQL Account for the first time or need to migrate financial data from other systems using Microsoft Excel (XLS) or CSV files, this page provides a straightforward solution. Here, you’ll find a detailed guide on how to effectively and effortlessly import your data into your SQL Accounting system
- Master file (eg. Debtors, Creditors & Item List)
- Transactions
- Nestle Transactions
- Yeos Transactions
- Coca-Cola Transactions
- GSK Transactions
Subject to Service Tax (SST)
Pros
☑️Easy to generate
☑️About 80% of modules is covered.
☑️Support GST/SST/E-Invoicing
☑️FREE import for Master file.
☑️Support Schedule Auto Download from Simple FTP - Only available in Version 5.10.6.32 & above
☑️Support Schedule Auto Import for Excel/CSV/TXT - Only available in Version 5.10.6.32 & above
☑️Support import CSV/TXT(Bar(|),Comma(,),Semi Comma(;),Tilde(~)) Format - Only available in Version 5.10.9 & above
☑️Support import Json Format - Only available in Version 5.11.10.43 & above
☑️No rows limit (but recommended max 500 rows per file as more records, more hard & time consumption to check if have error)
Cons
❌ Is Batch update.
❌ There is a cost for End User and Dealer for Transaction import. Only Free if each file record less then 100 rows.
❌ Unable to import Serial Number
Pros (UE Only) - (Deprecated)
☑️Easy to generate
☑️Able update Stock Information.
☑️Can do New/Insert/Edit/Update action
Cons (UE Only) - (Deprecated)
❌ There is a cost for End User and Dealer. Only Free if each file record less then 100.
❌ Only Cover Maintain Stock Item.
Requirement
- Firebird Server
- SQL Accounting
- Microsoft Excel or Access
