Android Question Excel Worksheet to DB file/MYSQL?

[hockeyadc]

I have a VBA program, that I am working on creating in Basic4Android. I have a large amount of data in worksheets, that I need to access and manipulate in Basic4Android.

Whats the best way to do this? Some kind of DB file or MYSQL? How do i do this/create the database?

Thanks!

 

[hockeyadc]

Ok. I have all my data in an SQLITE file/table. Where should I place this file so I can manipulate the data from it?

 

[Erel]

See DBUtils module.

You can include the db file in the Files tab and then at runtime call DBUtils.CopyDBFromAssets.

 

[hockeyadc]

Awesome thank you! I am not trying to assign a value from a specific column to an EditText field. How can I do that?

 

[Erel]

You will need to use the Excel library for that. However it is only available to licensed users.

 

[hockeyadc]

Thanks. I am most likely going to become a licensed user soon.