SQL Acc XLS n MDB Import

Introduction

Is External Program which able to import master file & transactions (Coming Soon) to SQL Accounting using Excel or Access File.

Pros

1. Easy to generate
2. About 80% of modules is covered.
3. Support GST
4. Free of Charge for End User (Master file import ONLY)

Cons

1. Only can do New/Insert action.

Tools Required

• Microsoft Excel or Access
• AccessDatabaseEngine.exe (optional)

Things to Consider

• Date Format should be in dd/mm/yyyy (entry time in Excel as dd/mm/yyyy) - Updated 14 Nov 2013

• If found Error external table is not in the expected format - Try save the file to other name using File | Save As in Excel