Frequently Asked
Questions
Find Solutions to Common Issues Related to data-conversion - access to sql vice versa
How to convert data from SQL to access
To convert data from SQL to access you need sql installed in your system
then follow the steps
1 create a demo company with same financial year in access mode and open it
2 go to administration menu and click on data export import
3 click on import data from sql
4 select the server name fill user Id and password of sql and click on blue arrow
5 then select the sql company from the list and select user name and password
then click to import
how to convert Sql 19 data into sql 17.
For convert sql 19 data into sql 17 follow these steps:
convert data into access then convert into sql 17.
For convert Sql data into access follow these steps:
1. create company in acess mode then go in administration
2. Then go in data export import click on import data from Sql
3. After import create company in sql 17
4. Then go in Administration then go in data export import
5. Click on import data from Access and import data
What is the process of data conversion in BUSY Accounting Software?
The process of data conversion in BUSY, please follow below steps :
Step 1: Go to Administration menu
Step 2: and then select Data Export Import submenu
Step 3: if you are using Access mode then showing Import data from SQL
Step 4: if you are using SQL mode then showing Import data from Access
Step 5: Please select as per your requirement.
Showing error - source company belong to old version on data converstion from SQL to Access
It is recomended to update the SQL or Access company data on current version while coverting data from SQL to Access or Access to SQL for convertion process follow the below steps
Step 1: open BUSY company
step 2 : go to adminstration then Data Export import and then Import data fro access or import data from SQL
Error while Import Data from Access to SQL.
Reasons for showing error while importing data from access to SQL are:
1. If the financial year is not exist in source data then it can show the Financial Year does not exist.
2. If shows permission denied error, you can exclude BUSY from antivirus properties.
How do I upgrade my BUSY database from access to SQL.
To upgrade your BUSY database from access to SQL, you will need to install SQL and then convert your data to SQL format.
Note: Installation of SQL and conversion of database is chargeable service.
I want to export my data from BUSY. How can I get access to the SQL data? Is there any charge for it?
Yes you can convert data access to the SQL data. Access to SQL data conversion is chargeable but you can do by your self in BUSY have inbuilt feature.
What is the process for converting my BUSY data from Access to SQL?
data conversion from Access to SQL, its chargeable services, it charges is 900 + GST 18%, per year per company.
What is the recommended data size limit in BUSY before I should switch from Access to SQL?
It is recommended to switch from Access to SQL in BUSY when the data size limit exceeds 2 GB.
What are the charges for converting my BUSY data from Access to SQL?
The charges for converting your BUSY data from Access to SQL is 900+GST per year per company.
