csv to sql

[gjoisa]

Is it possible to convert .csv file to sql database ? And how to get database from emulator which we created through Basic4android ?

 

[Erel]

You can copy files from and to a connected device / emulator with the 'ddms' tools.
It is located under <android-sdk>\Tools\ddms.bat.

Then press on the emulator and choose Device - File Explorer.

About the CSV file. You can easily parse a CSV file with StringUtils.LoadCSV.
Then you should go over the list of strings arrays and and insert the data to a SQL table. It is recommended to create one transaction for all the inserts.

 

[alfcen]

...or, please google for the free "SQLite Database Browser" which is capable of importing CSV.

 

[gjoisa]

Tried to load csv file . I used the code like this ;

dim su as StringUtils
dim table as List
lstplace as ListView
....
table=su.LoadCSV(File.DirAssets,"Adi.csv",",")
lstplace.Clear
For i=0 To table.Size-1
lstplace.AddSingleLine(table.Get(i))
Next
.

But while running , the list shows "[Ljava.lang.String;@43ea9b50"
and so on . What to do get the actual text which is in csv file ?

 

[Erel]

Each item in the 'table' variable is an array of strings (the complete row).
If you are dealing with a single column file then you can use File.ReadList instead of loading it as a CSV file.

 

[Merlot2309]

Hello,

For Mozilla Firefox there is a plugin "SQLite Manager" which works great for importing csv-files (also SQL and XML).

Helen.

 

[metzeller_2013]

@ All Sir I'm a Noobie here I am a bit confused, is SQL and SQlite the same thing?

 

[Erel]

You should have started a new thread for this question. The SQL library is based on the SQLite engine.