Database Formats

S

Sinimon

Member
Hello. i would like to know the fileformat of a database which can be used by basic4android. is the only format the ".db" - SQLite3 - format? I can not find a way to open this format with Visual Basic 6 ... :(
 
Sort by date Sort by votes
S

Sinimon

Member
could you explain what a csv file is and how i can convert the database to this file?? and also important: is it possible to reconvert the csv file to the database?
 
Upvote 0
stevel05

stevel05

Expert
Licensed User
Longtime User
Sorry, I read your post as though you wanted to work with SQLite databases within VB6.
 
Upvote 0
S

Sinimon

Member
i have a calender on PC.. i made it 2 years ago. the entrys are saved in a XLS excel file... it is easy to read...now i want to have a mobile version... the program is running on android... the database is running... but when i copy THIS database to my pc i can not open it with vb6.... i don´t know how it could happen.... i would tage every idea... if there is a better solution i would take another way and not sql... there are only problems for me :(
 
Upvote 0
stevel05

stevel05

Expert
Licensed User
Longtime User
OK, well the link from my first post may enable you to read the SQLite database in VB6.

Alternatively you could look at Xverhelstx's OfficeWorker Library (Although you have to be a registered user) which could enable you to work with Excel files. I don't know how far it's got I haven't tried it.
 
Upvote 0
S

Sinimon

Member
hm but... i can not download the library... you know why hm? :( what can i do now :( shit. i can not find a way to synchronize the pc with the mobile phone
 
Upvote 0
stevel05

stevel05

Expert
Licensed User
Longtime User
As I see it, you can either try to create/update an SQLite database from VB6 and import that into your app, or as Erel suggested export the data from the excel spreadsheet as a CSV and import that into your app.
 
Upvote 0
klaus

klaus

Expert
Licensed User
Longtime User
From what I see, you should:
- buy B4A :) it is it's money woth !
- save your Excel file to a csv file from Excel.
- then import it in B4A with StringUtils.
- genereate a SQLite database in B4A
And when you want to modify it on the PC there do exist free sortware to manage SQLite databases.

Best regards.
 
Upvote 0
luke2012

luke2012

Well-Known Member
Licensed User
Longtime User
Import directly into SQLite DB

It's possible to import a .csv file directly into a SQLite DB within B4A?
 
Upvote 0
You must log in or register to reply here.
Top