SQL Acc XLS n MDB Import: Revision history

From eStream Software

View logs for this page

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

curprev 01:2901:29, 22 May 2019‎ Twfaung talk contribs‎ 36,097 bytes +234‎ →‎My excel only had Barcode can it be import?

curprev 03:0503:05, 17 May 2019‎ Twfaung talk contribs‎ 35,863 bytes −125‎ →‎In My Excel Only had SSM or GST No. for Customer/Supplier can it be import?

curprev 01:0001:00, 13 May 2019‎ Twfaung talk contribs‎ 35,988 bytes +271‎ →‎History New/Updates/Changes

curprev 01:2201:22, 15 April 2019‎ Twfaung talk contribs‎ 35,717 bytes +269‎ →‎Import Program

curprev 09:0609:06, 1 April 2019‎ Twfaung talk contribs‎ 35,448 bytes 0‎ →‎Import Program

curprev 02:4402:44, 30 March 2019‎ Twfaung talk contribs‎ 35,448 bytes 0‎ →‎Import Program
curprev 02:3102:31, 30 March 2019‎ Twfaung talk contribs‎ 35,448 bytes +213‎ →‎Import Program

curprev 10:5610:56, 28 March 2019‎ Twfaung talk contribs‎ 35,235 bytes +113‎ →‎Example Template

curprev 09:3609:36, 21 March 2019‎ Twfaung talk contribs‎ 34,764 bytes −23‎ →‎History New/Updates/Changes
curprev 09:1009:10, 21 March 2019‎ Twfaung talk contribs‎ 34,787 bytes +157‎ →‎History New/Updates/Changes

curprev 00:3200:32, 16 March 2019‎ Twfaung talk contribs‎ 34,630 bytes +19‎ →‎History New/Updates/Changes
curprev 00:2800:28, 16 March 2019‎ Twfaung talk contribs‎ 34,611 bytes +338‎ →‎History New/Updates/Changes

curprev 06:0106:01, 13 March 2019‎ Twfaung talk contribs‎ 34,273 bytes +12‎ →‎Import Setting

curprev 02:4702:47, 8 March 2019‎ Twfaung talk contribs‎ 31,921 bytes +45‎ →‎My CSV data is 00123 but after get data become 123 (missing 00)?
curprev 02:4702:47, 8 March 2019‎ Twfaung talk contribs‎ 31,876 bytes +130‎ →‎Why it keep only load lst 100 records even I had registered?

curprev 10:3710:37, 13 February 2019‎ Twfaung talk contribs‎ 31,746 bytes −8‎ →‎Auto Import
curprev 10:3510:35, 13 February 2019‎ Twfaung talk contribs‎ 31,754 bytes +35‎ →‎Auto Import
curprev 10:2410:24, 13 February 2019‎ Twfaung talk contribs‎ 31,719 bytes +59‎ →‎Auto Import
curprev 09:3609:36, 13 February 2019‎ Twfaung talk contribs‎ 31,660 bytes +35‎ →‎Auto Import

curprev 00:4300:43, 7 January 2019‎ Twfaung talk contribs‎ 28,184 bytes +76‎ →‎Example Template
curprev 00:4200:42, 7 January 2019‎ Twfaung talk contribs‎ 28,108 bytes +30‎ →‎Import Program
curprev 00:3800:38, 7 January 2019‎ Twfaung talk contribs‎ 28,078 bytes +35‎ →‎Import Program

curprev 09:4609:46, 21 December 2018‎ Twfaung talk contribs‎ 26,813 bytes +165‎ →‎My excel only had Barcode can it be import?

curprev 04:1304:13, 19 December 2018‎ Twfaung talk contribs‎ 26,648 bytes −1‎ →‎History New/Updates/Changes

curprev 02:2002:20, 8 December 2018‎ Twfaung talk contribs‎ 26,649 bytes 0‎ →‎Import Program
curprev 02:1502:15, 8 December 2018‎ Twfaung talk contribs‎ 26,649 bytes −5‎ →‎History New/Updates/Changes

curprev 10:4210:42, 7 December 2018‎ Twfaung talk contribs‎ 26,654 bytes +302‎ →‎History New/Updates/Changes
curprev 10:4110:41, 7 December 2018‎ Twfaung talk contribs‎ 26,352 bytes +178‎ →‎Mini Utility

curprev 02:0702:07, 1 December 2018‎ Twfaung talk contribs‎ 25,305 bytes 0‎ →‎Import Program
curprev 02:0602:06, 1 December 2018‎ Twfaung talk contribs‎ 25,305 bytes +191‎ →‎History New/Updates/Changes

curprev 02:1502:15, 16 November 2018‎ Twfaung talk contribs‎ 25,114 bytes 0‎ →‎Import Program
curprev 02:0802:08, 16 November 2018‎ Twfaung talk contribs‎ 25,114 bytes +83‎ →‎History New/Updates/Changes (UE Only)
curprev 02:0802:08, 16 November 2018‎ Twfaung talk contribs‎ 25,031 bytes −15‎ →‎History New/Updates/Changes

curprev 07:5207:52, 12 November 2018‎ Twfaung talk contribs‎ 24,743 bytes +102‎ →‎History New/Updates/Changes
curprev 07:5007:50, 12 November 2018‎ Twfaung talk contribs‎ 24,641 bytes +3‎ →‎My excel Don't had account code if got ItemCode can it be import?
curprev 07:4907:49, 12 November 2018‎ Twfaung talk contribs‎ 24,638 bytes +164‎ →‎My excel Don't had account code if got ItemCode can it be import?

curprev 09:5909:59, 2 November 2018‎ Twfaung talk contribs‎ 24,474 bytes −30‎ →‎Import Program

curprev 10:5510:55, 30 October 2018‎ Twfaung talk contribs‎ 24,504 bytes +46‎ →‎History New/Updates/Changes

curprev 03:1903:19, 20 October 2018‎ Twfaung talk contribs‎ 24,392 bytes +135‎ →‎History New/Updates/Changes (UE Only)
curprev 03:1803:18, 20 October 2018‎ Twfaung talk contribs‎ 24,257 bytes +76‎ →‎History New/Updates/Changes

curprev 03:4103:41, 9 October 2018‎ Twfaung talk contribs‎ 24,063 bytes −6‎ →‎Example Template
curprev 03:2303:23, 9 October 2018‎ Twfaung talk contribs‎ 24,069 bytes +73‎ →‎History New/Updates/Changes
curprev 03:2203:22, 9 October 2018‎ Twfaung talk contribs‎ 23,996 bytes +11‎ →‎History New/Updates/Changes
curprev 03:2103:21, 9 October 2018‎ Twfaung talk contribs‎ 23,985 bytes +74‎ →‎History New/Updates/Changes

curprev 01:1601:16, 3 October 2018‎ Twfaung talk contribs‎ 23,911 bytes −174‎ →‎Example Template
curprev 01:1301:13, 3 October 2018‎ Twfaung talk contribs‎ 24,085 bytes +286‎ →‎Import Program

curprev 04:0304:03, 26 September 2018‎ Twfaung talk contribs‎ 23,799 bytes +102‎ →‎History New/Updates/Changes
curprev 04:0304:03, 26 September 2018‎ Twfaung talk contribs‎ 23,697 bytes −101‎ →‎Todo & Know Bugs
curprev 03:1603:16, 26 September 2018‎ Twfaung talk contribs‎ 23,798 bytes +132‎ →‎History New/Updates/Changes
curprev 03:1603:16, 26 September 2018‎ Twfaung talk contribs‎ 23,666 bytes −62‎ →‎Todo & Know Bugs

curprev 03:4603:46, 18 August 2018‎ Twfaung talk contribs‎ 23,728 bytes +49‎ →‎Todo & Know Bugs
curprev 03:4403:44, 18 August 2018‎ Twfaung talk contribs‎ 23,679 bytes +89‎ →‎Todo & Know Bugs
curprev 03:3003:30, 18 August 2018‎ Twfaung talk contribs‎ 23,590 bytes +113‎ →‎Todo

curprev 01:4101:41, 24 April 2018‎ Twfaung talk contribs‎ 23,477 bytes +304‎ →‎My excel String size is longer then SQL, how I can reduce it?

curprev 01:3501:35, 16 April 2018‎ Twfaung talk contribs‎ 23,173 bytes −14‎ →‎Import Program

curprev 00:4500:45, 11 April 2018‎ Twfaung talk contribs‎ 23,187 bytes +204‎ →‎History New/Updates/Changes

curprev 06:1806:18, 5 April 2018‎ Twfaung talk contribs‎ 22,983 bytes +100‎ →‎History New/Updates/Changes

curprev 01:4001:40, 4 April 2018‎ Twfaung talk contribs‎ 22,883 bytes −3‎ →‎Tools Required
curprev 01:3801:38, 4 April 2018‎ Twfaung talk contribs‎ 22,886 bytes +35‎ →‎Tools Required

curprev 11:4611:46, 29 March 2018‎ Twfaung talk contribs‎ 22,851 bytes +15‎ →‎How to add file link in the Attachments Fields?
curprev 11:4611:46, 29 March 2018‎ Twfaung talk contribs‎ 22,836 bytes +18‎ →‎How to add file link in the Attachments Fields?
curprev 11:4511:45, 29 March 2018‎ Twfaung talk contribs‎ 22,818 bytes +119‎ →‎How to add file link in the Attachments Fields?
curprev 01:4501:45, 29 March 2018‎ Twfaung talk contribs‎ 22,699 bytes +23‎ →‎Cons

curprev 01:0401:04, 24 March 2018‎ Twfaung talk contribs‎ 22,676 bytes 0‎ →‎Import Program
curprev 00:5500:55, 24 March 2018‎ Twfaung talk contribs‎ 22,676 bytes −15‎ →‎History New/Updates/Changes

curprev 01:3501:35, 23 March 2018‎ Twfaung talk contribs‎ 22,691 bytes 0‎ →‎Example Template

curprev 06:3806:38, 21 March 2018‎ Twfaung talk contribs‎ 22,691 bytes −6‎ →‎History New/Updates/Changes
curprev 06:2406:24, 21 March 2018‎ Twfaung talk contribs‎ 22,697 bytes +38‎ →‎History New/Updates/Changes
curprev 06:1306:13, 21 March 2018‎ Twfaung talk contribs‎ 22,659 bytes +70‎ →‎Import Program

curprev 00:3800:38, 16 March 2018‎ Twfaung talk contribs‎ 21,885 bytes −1‎ →‎Introduction
curprev 00:3500:35, 16 March 2018‎ Twfaung talk contribs‎ 21,886 bytes +68‎ →‎Introduction

curprev 07:3907:39, 7 March 2018‎ Twfaung talk contribs‎ 21,818 bytes +25‎ →‎Things to Consider

curprev 01:4301:43, 3 March 2018‎ Twfaung talk contribs‎ 21,793 bytes +149‎ →‎Import Program

curprev 04:3204:32, 2 March 2018‎ Twfaung talk contribs‎ 21,644 bytes −16‎ →‎Prompt "Provider cannot be found. It may not be properly installed" when Get file from excel

curprev 00:3400:34, 22 February 2018‎ Twfaung talk contribs‎ 21,660 bytes +161‎ →‎Import Program

curprev 02:0402:04, 21 February 2018‎ Twfaung talk contribs‎ 21,499 bytes +1‎ →‎My excel String size is longer then SQL, how I can reduce it?
curprev 02:0302:03, 21 February 2018‎ Twfaung talk contribs‎ 21,498 bytes +1‎ →‎My Excel for Credit Note/Payment is in Negative Value, can it be import?
curprev 02:0302:03, 21 February 2018‎ Twfaung talk contribs‎ 21,497 bytes +2‎ →‎My excel date format is in YYYYMMDD format, how I convert it to dd/MM/yyyy?

curprev 04:5904:59, 14 February 2018‎ Twfaung talk contribs‎ 19,539 bytes +93‎ →‎Example Template

curprev 01:1901:19, 12 February 2018‎ Twfaung talk contribs‎ 19,446 bytes +17‎ →‎Prompt "Provider cannot be found. It may not be properly installed" when Get file from excel

curprev 02:4802:48, 21 December 2017‎ Twfaung talk contribs‎ 17,595 bytes +324‎ →‎Import Program

curprev 07:4107:41, 8 November 2017‎ Twfaung talk contribs‎ 17,271 bytes +20‎ →‎Prompt "Error Unexpected error from external database driver (1)" when Get file from excel

curprev 10:2410:24, 21 September 2017‎ Twfaung talk contribs‎ 16,494 bytes +32‎ →‎Todo

curprev 09:3609:36, 14 September 2017‎ Twfaung talk contribs‎ 16,462 bytes +81‎ →‎Todo

curprev 04:0304:03, 28 August 2017‎ Twfaung talk contribs‎ 16,381 bytes +50‎ →‎In My Excel Only had SSM or GST No. for Customer/Supplier can it be import?

curprev 04:1704:17, 26 August 2017‎ Twfaung talk contribs‎ 16,331 bytes +272‎ →‎My Excel for Credit Note/Payment is in Negative Value, can it be import?
curprev 04:1204:12, 26 August 2017‎ Twfaung talk contribs‎ 16,059 bytes −79‎ →‎Todo
curprev 04:1004:10, 26 August 2017‎ Twfaung talk contribs‎ 16,138 bytes +410‎ →‎Import Program

curprev 00:3700:37, 19 August 2017‎ Twfaung talk contribs‎ 15,728 bytes −11‎ →‎Example Template

curprev 09:4109:41, 19 June 2017‎ Twfaung talk contribs‎ 15,464 bytes +4‎ →‎History New/Updates/Changes
curprev 09:4009:40, 19 June 2017‎ Twfaung talk contribs‎ 15,460 bytes +193‎ →‎Example Template
curprev 09:1409:14, 19 June 2017‎ Twfaung talk contribs‎ 15,267 bytes +95‎ →‎Split Memo to Columns
curprev 09:1309:13, 19 June 2017‎ Twfaung talk contribs‎ 15,172 bytes +72‎ →‎Check Duplicate Records

curprev 02:2102:21, 17 June 2017‎ Twfaung talk contribs‎ 15,100 bytes +44‎ →‎Convert Rows to Columns

curprev 10:1610:16, 29 May 2017‎ Twfaung talk contribs‎ 12,421 bytes +335‎ →‎Why My Excel data shown as eg 5% but once I Get File become 0.05?

curprev 07:5407:54, 8 May 2017‎ Twfaung talk contribs‎ 11,814 bytes 0‎ →‎Example Template

curprev 00:3900:39, 2 May 2017‎ Twfaung talk contribs‎ 11,814 bytes +726‎ →‎Import Program

curprev 10:0410:04, 28 April 2017‎ Twfaung talk contribs‎ 11,088 bytes +54‎ →‎Can I import without Tax Amount (i.e. SQL Account auto Calculate the Tax Amount)?

curprev 06:0106:01, 8 March 2017‎ Twfaung talk contribs‎ 11,034 bytes +268‎ →‎Import Program

curprev 03:3603:36, 1 March 2017‎ Twfaung talk contribs‎ 10,766 bytes +36‎ →‎Todo

curprev 09:0909:09, 24 January 2017‎ Twfaung talk contribs‎ 10,730 bytes −38‎ →‎Todo
curprev 09:0409:04, 24 January 2017‎ Twfaung talk contribs‎ 10,768 bytes +3‎ →‎Todo

curprev 04:5804:58, 4 January 2017‎ Twfaung talk contribs‎ 10,765 bytes 0‎ →‎Import Program

Retrieved from "https://wiki.sql.com.my/wiki/SQL_Acc_XLS_n_MDB_Import"