Prev: Modeless window in background
Next: [SOLVED] Views - Ado with Access databases
From: Carlos Rocha on 19 Mar 2010 22:04
Hi,

I need to use Ado (Vo2Ado) to import an Access database (mdb) to a
SQLite database.
In SQLite there is a system table called SQLITE_MASTER that holds some
of the relevant information about the database.
In this table there is a column named SQL that stores the DDL used to
create the Tables and Views.
I need the DDL used to create the Views in the mdb to recreate them in
SQLite, but can't find nothing in their system tables.
I know the DDL is there, somewhere, because I download a program that
takes it out from a mdb, but I need to do it from my program.
Does anyone know a way to do it?

Thanks
--
Carlos Rocha
 | 
Pages: 1
Prev: Modeless window in background
Next: [SOLVED] Views - Ado with Access databases