SQL Acc XLS n MDB Import: Difference between revisions

From eStream Software
Line 28: Line 28:


==Import Program==
==Import Program==
* Version (4.1.1.5) - 07 Jun 2015
* 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
* http://www.estream.com.my/downloadfile/Fairy/SQLAccXLSnMDBImp-setup.exe


Line 39: Line 40:
* Add Default Value for Stock Item CostingMethod field.
* Add Default Value for Stock Item CostingMethod field.


* Version (4.1.1.7) - 14 Sep 2015
===History New/Updates/Changes (UE Only)===
* For SQLAcc XLS n MDB Import UE
--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==
==Steps==

Revision as of 07:15, 14 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

  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

Example Template

Things to Consider

  • Date Format should be in dd/mm/yyyy (entry time in Excel as dd/mm/yyyy) - Updated 14 Nov 2013
Excel-DateFormat.jpg
  • 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

Import Program

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