List of Accounting can be import to SQL Accounting: Difference between revisions

From eStream Software
No edit summary
No edit summary
Line 99: Line 99:
StockGroup<br>
StockGroup<br>
| 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
|-
| ESoft Accounting ||  align="center" | MYSQL || 
MySQL Backup in .sql & zip<br>
apvend.sql<br>
arcust.sql<br>
| align="center" | sql ||  Y (Except GL Maintain Account & Stock) || align="center" | N || align="center" | N
|}
|}

Revision as of 08:04, 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
Debtor
Stock
StockGroup

GDB
GZB
QIB

Y (Except GL Maintain Account) N N
QnE (MSSQL) MSSQL

MSSQL Backup
Debtors
Creditors
stocks

BAK Y (Except GL Maintain Account) N N
Mr Accounting(MSSQL) MSSQL

MSSQL Backup
Currency_Setting
Customer
Salesman
StockMasterDetails
SupplierDetail

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
AcCard.DB
(Use Office XP to Open)

DB Y (Except GL Maintain Account) N N
Smart Accounting(MSSQL) MSSQL

MSSQL Backup AcStk
AcCard

BAK Y (Except GL Maintain Account) N N
AccSys Business Information System MSSQL

MSSQL Backup Company
Product

BAK Y (Except GL Maintain Account) N N
Million Business Software MSSQL

MSSQL Backup Customer
Supplier
Product
Prodgrp

BAK Y (Except GL Maintain Account) N N
ICS Accounting MS Access

Cred6000
Debt6000

MDB Y (Except GL Maintain Account) N N
APlus DBase

Customer
Vendor
Stock

DBF Y (Except GL Maintain Account) N N
MYOB MYO

addr.csv
cards.csv
chacc.csv
items.csv
terms.csv
(CSV files generated using myData CLI tool)

DBF Y N N
Master Accounting MSSQL

MSSQL Backup
Debtor
Creditor
Stock
StockGroup

BAK Y (Except GL Maintain Account) N N
ESoft Accounting MYSQL

MySQL Backup in .sql & zip
apvend.sql
arcust.sql

sql Y (Except GL Maintain Account & Stock) N N