| Line 18: | Line 18: | ||
* Date Format should be in dd/mm/yyyy (entry time in Excel as dd/mm/yyyy) - Updated 14 Nov 2013 | * Date Format should be in dd/mm/yyyy (entry time in Excel as dd/mm/yyyy) - Updated 14 Nov 2013 | ||
::[[File:Excel-DateFormat.jpg|500px]] | ::[[File:Excel-DateFormat.jpg|500px]] | ||
* If found Error '''external table is not in the expected format''' - Try save the file to other name using '''File | Save As''' in Excel | |||
Revision as of 02:44, 15 August 2015
Introduction
Is External Program which able to import master file & transactions (Coming Soon) to SQL Accounting using Excel or Access File.
Pros
- Easy to generate
- About 80% of modules is covered.
- Support GST
- Free of Charge for End User (Master file import ONLY)
Cons
- 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