Database to CSV

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Mar 31, 2011

• #2

You can load and save CSV files with the StringUtils library: Basic4android - StringUtils

 

Upvote 0

A

anakaine

Member

• Apr 21, 2013

• #3

I've got to say - when the OP was asking for an example I was also hoping to see an example as a respondent. The StringUtils page doesn't have a very good demonstration of read/write/store - just an example of the syntax. It's quite difficult to understand as someone entering programming.

 

Upvote 0

D

Dman

Active Member

Licensed User

Longtime User

• Apr 21, 2013

• #4

Here's what I use

B4X:

Dim table1 As List
      table1 = DBUtils.ExecuteMemoryTable(SQL1, "SELECT * FROM yourtable", Null, 0) 
      Dim si As StringUtils
         si.SaveCSV(yourdir, "yourfilename.csv", ";", table1)
         table1.Clear

 

Upvote 0

A

anakaine

Member

• Apr 21, 2013

• #5

Thank you! That is excellent

 

Upvote 0

D

Dman

Active Member

Licensed User

Longtime User

• Apr 22, 2013

• #6

No problem. I got that code straight from this place.

 

Upvote 0