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 ...
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?
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
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.
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.
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.
No, not directly.
You can load a csv file with LoadCCV or LoadCSV2 from the StringUtils library.
But then you must create the database by code, but this is done once.