Line 26: | Line 26: | ||
* Float, Currency & Integer type Must not had ''',''' (comma) or Currency '''Symbol''' | * Float, Currency & Integer type Must not had ''',''' (comma) or Currency '''Symbol''' | ||
* If Prompt Error '''external table is not in the expected format''' - Try save the file to other name using '''File | Save As''' in Excel | * If Prompt Error '''external table is not in the expected format''' - Try save the file to other name using '''File | Save As''' in Excel | ||
* Below is the excel need type column can/can't import | |||
::[[File:Excel-Import-02.jpg|500px]] | |||
==Import Program== | ==Import Program== |
Revision as of 07:50, 19 September 2015
Introduction
Is an External Program which able to import below data to SQL Accounting using Excel or Access File.
- Master file (eg. Debtors, Creditors & Item List)
- Transactions (Coming Soon)
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)
Example Template
- Updated 10 Nov 2014
- www.estream.com.my/document/SQLAcc-ImportExcel.xls
Things to Consider
- Date Format should be in dd/mm/yyyy (entry time in Excel as dd/mm/yyyy) - Updated 14 Nov 2013
- Float, Currency & Integer type Must not had , (comma) or Currency Symbol
- If Prompt Error external table is not in the expected format - Try save the file to other name using File | Save As in Excel
- Below is the excel need type column can/can't import
Import Program
- Version (4.1.1.5) - 07 Jun 2015
- Version (4.1.1.7) - 14 Sep 2015 (UE Only)]
- http://www.estream.com.my/downloadfile/Fairy/SQLAccXLSnMDBImp-setup.exe
History New/Updates/Changes
--Build 5--
- Upgrade to Version 4.
- Upgrade to XE7.
- Add Split Record - To cater large Record Data File.
- Remove readonly="true" SUBTYPE="Autoinc" before append Data.
- Add Default Value for Stock Item CostingMethod field.
History New/Updates/Changes (UE Only)
--Build 7--
- Fixed “Bad variable type” error.
- Fixed some field no default value.
--Build 6--
- Upgrade to Version 4.
- Upgrade to XE7.
- Add Split Record - To cater large Record Data File.
- Remove readonly="true" SUBTYPE="Autoinc" before append Data.
- Add Default Value for Stock Item CostingMethod field.
- Add New filter function for data.
Steps
- Coming Soon....
See also
- Others Customisation