First of all, this wisdom isn't mine. I found it on the internet when i wanted to convert an MS Access database. As this could be helpfull to other B4PPC users i will quote the text here. Thanks to SSIDE for the following text.
1-Export the access database into text files, semicolon or comma delimited.
2-Open the SQLite database browser version 1.1 and chose file->import->table from csv file. Browse for your text file and choose the proper delimiter. Click create.
3-Done.
I assume that you have already a access database and you have already created a sqlite database with the proper table. Before you import the text file (csv file) into sqlite you must open the sqlite database where you want to import the text file (csv file) to. If you have created no table then the opportunity will be given to create one or to use the first line of the text file (csv file) to create the fields (columns).
Another way to create sqlite database from access or from excel is to save each column into a text file. That means a table with 7 columns = 7 text files. Use TextFile.ReadToTable to read the contents of the 7 text files into tables and use the for loop to load them into a sqlite database.
There are other ways to convert access database or excel doc into sqlite database but i described 2 of them.
I have used similar ways to create sql databases but in some occassions you need a php script.
The SQLite database browser can be found at http://sqlitebrowser.sourceforge.net. The latest version is 1.3.
I've tried it and it works as a charm. Mind you, it can take a very long time to convert a large table.
Peter
1-Export the access database into text files, semicolon or comma delimited.
2-Open the SQLite database browser version 1.1 and chose file->import->table from csv file. Browse for your text file and choose the proper delimiter. Click create.
3-Done.
I assume that you have already a access database and you have already created a sqlite database with the proper table. Before you import the text file (csv file) into sqlite you must open the sqlite database where you want to import the text file (csv file) to. If you have created no table then the opportunity will be given to create one or to use the first line of the text file (csv file) to create the fields (columns).
Another way to create sqlite database from access or from excel is to save each column into a text file. That means a table with 7 columns = 7 text files. Use TextFile.ReadToTable to read the contents of the 7 text files into tables and use the for loop to load them into a sqlite database.
There are other ways to convert access database or excel doc into sqlite database but i described 2 of them.
I have used similar ways to create sql databases but in some occassions you need a php script.
The SQLite database browser can be found at http://sqlitebrowser.sourceforge.net. The latest version is 1.3.
I've tried it and it works as a charm. Mind you, it can take a very long time to convert a large table.
Peter