Loading GST Billing Software
header image

Kushal Help : Create Database Using Excel Definition

Erachana Line

ExceltoDB

This is a very handy feature to create the database structure by using excel files, especially for someone who finds it difficult to create a database via traditional approaches. By using this feature you can define database structures easily. You can create databases of the following Types.

  1. MS SQL.
  2. MySQL.
  3. SQLite.
  4. MS Access.


Click on Create DB from Excel.

The DB Creator will open.



Click on the Template Button. This will open the Excel Template file.


Enter the table name, field names and select the required fields like Data type, Length, Required, Primary Key, Reference Key, Reference Table.


Here you can create any number of tables at a time.

Save the Template Excel Sheet in the particular directory which is having read and write permission.

Select the Database type in the DB Creator.


MS SQL

Note: If you are creating the Database in the “MS SQL Server with Windows Authentication” Select the MS SQL Integrated Security option.


Enter the Server Credentials.

If you are creating the Database in the “MS SQL Server with Server Authentication” Select the MS SQL option.



Enter the Server Credentials.



To test the connection click on the Test connection button, you will get a confirmation message upon success, if you have provided proper credentials.



Enter the Database name, which you want to create on the server (Please ensure that given database is not present in your server already).



Select the Excel Sheet where you have created the table structure using the Template.



Then Click on the Create button.

After creation of the database and its tables, Confirmation message will pop-up.



MySQL

For MySQL Database select the MySQL option from the list.



Select the path of the MySQL Database drivers which are installed in your system.
Ex: In the following path you will get the reference files
Path : C:\Program Files\MySQL\MySQL Connector Net 6.6.5\Assemblies\v2.0\MySQL.Data.dll


Enter the Server Credentials.



To test the connection click on the Test connection button, you will get a confirmation message if you have provided the proper credentials.



Enter the Database name, which you want to create in the server. (Please ensure that given database is not present in your server already).



Select the Excel file where you have created the table structure using the Template.



Then Click on the Create button.

After creation of the database and its tables, Confirmation message will pop-up.



SQLite



Select the location where the SQLite Database file needs to get created.

Enter the Database name, which is considered as the file name.

Select the Excel file which you have created the table structure using the Template.

Then Click on the Create button.

After creation of the database and its tables (DB file), a confirmation message will pop-up.



MS Access



Select the location where the MS Access Database file needs to get created.

Enter the Database name, which is considered as the file name.

Select the Excel file where you have created the table structure using the Template.

Then Click on the Create button.

After creation of the database and its tables (DB file), a confirmation message will pop-up.



Another good Feature of Kushal is the creation of SQL Queries of the created database.

Click on the SQL Button.

All query of the Database will get created in the text file(Create statements)