Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Using QspatiaLite plugin in QGIS I'm able to create a new database and work with it (load/edit/import/export data). But how can I add a connection to an existing database? How to add an existing database to the drop-down-menu of the available database connections?

share|improve this question
up vote 2 down vote accepted

You just use the same "New DB" button. If you mouse-over the button the tip says "(you can also load an existing one, just ignore the replace)".

It's very non-intuitive, and should be changed, but it works. When you point to an existing DB a warning pops up that the DB already exists and you must click "Replace" (despite the warning) then the existing tables load.

share|improve this answer
Thanks! I did not notice the tooltip. I tried to use the 'New DB' button but I stopped going on when popped-upthe alert saying "A file or folder with the same name already exists in the folder sqlite. Replacing it will overwrite its current contents.". Another way to add a connection is loading a sqlite layer from the sqlite DB, using QGIS Layer > Add Vector Layer. I found this adds a new item in the drop-down menu of the plugin. Maybe a more intuitive UI would help. It's a very useful plugin! – bradypus Apr 20 '12 at 9:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.