How to convert data from excel to sqllite database

How to convert data from excel to sqllite database

1.Take the excel sheet where you have your data

2.convert the excel sheet into .csv file(means excel sheet save as .csv file)

3.open sqlite database

4.create database and table

5.create fields in table as excel sheet fields.(names in excel sheet i mean)

6.click import and select the .csv file

7.type the table name(your created) and fill details

8.click OK

Excel sheet is converted into sqlite database

How to convert a number(integer) to a string?

The standard C library provides several functions for converting numbers of all formats (integers, longs, floats, and so on) to strings and vice versa The following functions can be used to convert integers to strings:
Function Name Purpose
itoa() Converts an integer value to a string.
ltoa() Converts a long integer value to a string.
ultoa() Converts an unsigned long integer value to a string.
The following functions can be used to convert floating-point values to strings:
Function Name Purpose
ecvt() Converts a double-precision floating-point value to a string without an embedded decimal point.
fcvt() Same as ecvt(), but forces the precision to a specified number of digits.
gcvt() Converts a double-precision floating-point value to a string with an embedded decimal point.