SQL Acc XLS n MDB Import: Difference between revisions

From eStream Software
No edit summary
Line 13: Line 13:
==Tools Required==
==Tools Required==
* Microsoft Excel or Access
* Microsoft Excel or Access
* AccessDatabaseEngine.exe (optional)
* [http://www.microsoft.com/en-us/download/details.aspx?id=23734 AccessDatabaseEngine.exe] (optional)


==Things to Consider==
==Things to Consider==
* 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]]

Revision as of 02:41, 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

  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

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