No announcement yet.

How to convert access database to sqlite database.

  • Filter
  • Time
  • Show
Clear All
new posts

  • How to convert access database to sqlite database.

    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.

    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.

  • #2
    How can create a sqlite database using a php program ? any help ?


    • #3
      Access to SQLite

      I have a conversion tool that will do this but I cant post it on forrum because it is an .exe file. Please send me an e-mail and I will send you the program.
      [email protected]