List of Accounting can be import to SQL Accounting

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 CreditorArea CreditorCategory Currency Debtor DebtorArea DebtorCategory Stock StockCategory StockGroup StockLocation Term	GDB QZB 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
Emas(MYSQL)	MYSQL	MySQL Backup in .sql & zip YYYYMMDD_ACCxxxxx.sql apvend arcust currency glarea glagent	sql	Y (Except GL Maintain Account & Stock)	N	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 Currency Customer Product Prodgrp Project Supplier	BAK	Y (Except GL Maintain Account)	N	N
ICS Accounting	MS Access	Cred6000 Debt6000	MDB	Y (Except GL Maintain Account)	N	N
APlus	DBase	agent.dbf area.dbf currency.dbf customer.dbf vendor.dbf stock.dbf	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)	MYO	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 xxxxx.apvend.sql xxxxx.arcust.sql	sql	Y (Except GL Maintain Account & Stock)	N	N
iFAS Accounting	MSSQL	MSSQL Backup AP_VENDOR_MASTER AR_CUSTOMER_MASTER AREA_MASTER CURR INV_CATEGORY_MASTER INV_GROUP INV_ITEM_MASTER INV_LOCATION_MASTER	BAK	Y (Except GL Maintain Account)	N	N
Remicle	PostgreSQL	Remicle PostgreSQL database dump backup in .sql & zip product_product<vr> res_partner	sql	Y (Except GL Maintain Account)	N	N

* EMAS Chart of Account - will only assign bank account special type if detected. The rest of accounts need customer re-check.

Highlighted with background mean direct import to SQL Database else will export to Excel or CSV file

See also

• Data Import