SQL Acc XLS n MDB Import: Difference between revisions

From eStream Software
Line 14: Line 14:
* Microsoft Excel or Access
* Microsoft Excel or Access
* [http://www.microsoft.com/en-us/download/details.aspx?id=23734 AccessDatabaseEngine.exe] (optional)
* [http://www.microsoft.com/en-us/download/details.aspx?id=23734 AccessDatabaseEngine.exe] (optional)
==Example Template==
[http://www.sql.com.my/document/SQLAcc-ImportExcel.xls www.sql.com.my/document/SQLAcc-ImportExcel.xls]


==Things to Consider==
==Things to Consider==

Revision as of 06:04, 24 August 2015

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

Example Template

www.sql.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
Excel-DateFormat.jpg
  • If found 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.