SQL Acc XLS n MDB Import: Difference between revisions

From eStream Software
(Created page with "==Introduction== Is External Program which able to import master file & transactions (Coming Soon) to SQL Accounting using Excel or Access File. ==Tools Required== * Microsof...")
 
Line 6: Line 6:
* AccessDatabaseEngine.exe (optional)
* AccessDatabaseEngine.exe (optional)


==Thing 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|650px]]

Revision as of 02:35, 15 August 2015

Introduction

Is External Program which able to import master file & transactions (Coming Soon) to SQL Accounting using Excel or Access File.

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
Excel-DateFormat.jpg