Topic: excel tables

Can you import data from an existing database file (DBF) or excel spread sheet?

Re: excel tables

Possible, but the procedure can be as simple or complex, depending on the complexity of your current database.

For Import you can use free tool SQLiteStudio.

Dmitry.

Re: excel tables

Thank you. Once I figured it out the tables were easily imported into sqlitestudio. The question now is how do I get them into My visual DB?

Re: excel tables

1. Open the database file "sqlite.db" in SQLiteStudio.
2. Make the necessary import data into the database.
3. The new data will be seen also in My Visual Database.

Dmitry.