List of Accounting can be import to SQL Accounting: Difference between revisions
From eStream Software
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
! Product !! File Type !! File/Table Name !! File Type Extention !! Master File 90% Accurate !! Opening Balance 70%-80% Accurate !! Current Transactions 70%~80% Accurate | ! Product !! File Type !! File/Table Name !! File Type Extention !! Master File 90% Accurate !! Opening Balance 70%-80% Accurate !! Current Transactions 70%~80% Accurate | ||
|- | |- | ||
| Autocount - Acc 2000, XP, Professional, Premier30 & Premier35 || Paradox || AutoCount Backup || align="center" |B01 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding Information) | | Autocount - Acc 2000, XP, Professional, Premier30 & Premier35 || align="center" |Paradox || AutoCount Backup || align="center" |B01 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding Information) | ||
|- | |- | ||
| Autocount Enterprise 2005 || MSSQL || AutoCount Backup || align="center" |A06 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding | | Autocount Enterprise 2005 || align="center" |MSSQL || AutoCount Backup || align="center" |A06 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding | ||
|- | |- | ||
| UBS Accounting || Foxpro || UBS Backup || align="center" | ACC || align="center" | Y || align="center" | Y || align="center" | N | | UBS Accounting || align="center" |Foxpro || UBS Backup || align="center" | ACC || align="center" | Y || align="center" | Y || align="center" | N | ||
|- | |- | ||
| UBS Stock || Foxpro || UBS Backup || align="center" | STK || align="center" | Y || align="center" | Y || align="center" | N | | UBS Stock || align="center" |Foxpro || UBS Backup || align="center" | STK || align="center" | Y || align="center" | Y || align="center" | N | ||
|- | |- | ||
| QnE || Firebird || | | QnE || align="center" |Firebird || | ||
Creditor<br> | Creditor<br> | ||
Debtor<br> | Debtor<br> | ||
| Line 22: | Line 22: | ||
|| Y (Except GL Maintain Account) || align="center" | N || align="center" | N | || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | ||
|- | |- | ||
| QnE (MSSQL) || MSSQL || | | QnE (MSSQL) || align="center" |MSSQL || | ||
MSSQL Backup<br> | MSSQL Backup<br> | ||
Debtors<br> | Debtors<br> | ||
| Line 29: | Line 29: | ||
| align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | | align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | ||
|- | |- | ||
| Mr Accounting(MSSQL) || MSSQL || | | Mr Accounting(MSSQL) || align="center" |MSSQL || | ||
MSSQL Backup<br> | MSSQL Backup<br> | ||
Currency_Setting<br> | Currency_Setting<br> | ||
| Line 38: | Line 38: | ||
| align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | | align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | ||
|- | |- | ||
| 3A Accounting (Windows) || MS Access || | | 3A Accounting (Windows) || align="center" |MS Access || | ||
Crdat.mdb | Crdat.mdb | ||
DbDat.mdb | DbDat.mdb | ||
Revision as of 06:56, 29 December 2022
| Product | File Type | File/Table Name | File Type Extention | Master File 90% Accurate | Opening Balance 70%-80% Accurate | Current Transactions 70%~80% Accurate |
|---|---|---|---|---|---|---|
| Autocount - Acc 2000, XP, Professional, Premier30 & Premier35 | Paradox | AutoCount Backup | B01 | Y | Y | Y (Except Sales & Purchase Outstanding Information) |
| Autocount Enterprise 2005 | MSSQL | AutoCount Backup | A06 | Y | Y | Y (Except Sales & Purchase Outstanding |
| UBS Accounting | Foxpro | UBS Backup | ACC | Y | Y | N |
| UBS Stock | Foxpro | UBS Backup | STK | Y | Y | N |
| QnE | Firebird |
Creditor |
GDB |
Y (Except GL Maintain Account) | N | N |
| QnE (MSSQL) | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
| Mr Accounting(MSSQL) | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
| 3A Accounting (Windows) | MS Access |
Crdat.mdb DbDat.mdb Stdat.mdb |
MDB | Y (Except GL Maintain Account) | N | N |
| Emas | Foxpro | Emas Backup | EMS | Y* | Y | N |
| Smart Accounting |
AcStk.DB |
DB | Y (Except GL Maintain Account) | N | N | |
| Smart Accounting(MSSQL) | MSSQL |
AcStk |
BAK | Y (Except GL Maintain Account) | N | N |