Android Question Batch SQL query

Using batch inserts

http://www.b4x.com/android/forum/threads/sql-tutorial.6736/

Declare two variables

dim m as map
dim l as list

m.initialize
l.initialize


for each field you want to add
I do not know the source of your data

read from source loop

m.put("dbfield1",yourfield1value)
m.put("dbfield2",yourfield2Value)
m.put("dbfield3",yourfield3Value)
l.add(m)


once you have all the records added to the list use dbutils class

dbutils.insertmaps(sql,"YourTable",l)

is there any way to run directly a file... as my friend and i are working separately..
he has created sql files for me to set up database which contains thousands of line.. i can use excel and surround sql commands with m.put or something similar...
But i was looking for some long term solution...Still thanks for the input...

You can read the file with File.ReadList (or any other way) and then submit the queries.