Android Question How to create sql table from csv file ?

Sort by date Sort by votes

Andrew (Digitwell)

Well-Known Member
Licensed User
Longtime User
Have you seen this?

Csv to SQLite program

Attached you find a small project to convert csv files to a SQLite database. The program: - detects automatically between the two separator characters ',' ';'. - determines, on request, the data type for each column (TEXT, REAL, INREGER), these can be changed. - the column names are the values...
www.b4x.com
 
Upvote 0
V

Volga_

Member
Yes, I have seen it. But I am working with B4A, not B4J. Can you support me more ? Thanks.
 
Upvote 0

Mariano Ismael Castro

Active Member
Licensed User
Volga_ said:
Yes, I have seen it. But I am working with B4A, not B4J. Can you support me more ? Thanks.
Click to expand...
You should certainly explore what they recommended to you. I attached a small example (perhaps with defects) that could help you in what you are looking for.
It is mostly compilation of code. Overcoat by B4XTable
 

Attachments

  • CSV_To_SQLite.zip
    23.2 KB · Views: 129
Upvote 0
V

Volga_

Member
Thanks Mahares, I want to have a simple version for learning, I'm very happy if you give me it.
 
Upvote 0
M

Mahares

Expert
Licensed User
Longtime User
Volga_ said:
I want to have a simple version for learning, I'm very happy if you give me it.
Click to expand...
I sent you as PM a complete simple project to import a CSV file into a SQLite table. If it satisfies you and find it easy to learn, let me know so I can post it to the rest of the emmbers who are interested.
 
Upvote 0
M

Mahares

Expert
Licensed User
Longtime User
As promised, I created a simple B4XPages project with its details in the 'Examples' forum at the following link :

Import a CSV Text File Into a Newly Created SQLite Table

1. I use StringUtils library to import the CSV text file into the SQLite table. There are other ways to import like, such as CSVParser class module, RegEx.Split and TextReader, although TextReader is no longer recommended by the community. 2. The text file in this project has a semi colon as...
www.b4x.com
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
B4A Library Introducing liteCsvParse: A Lightweight Library for Efficient CSV Processing
Replies
1
Views
657
carlos7000
  • Article
B4A Library xCSVHelper - wrapper from Apache Commons CSV
Replies
4
Views
972
RB Smissaert
R
  • Article
B4A Library [B4X] CSVParser - CSV parser and generator
Replies
5
Views
10K
LucaMs
  • Article
Android Tutorial [B4X] B4XTable - Editable table and export to CSV
Replies
5
Views
14K
Erel
  • Locked
  • Article
B4A Library [B4X] B4XTable - Cross platform, sortable, searchable, customizable table
2
Replies
28
Views
61K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…