This may be an issue with the odbc driver. In the meanwhile, you could try importing with the gui tool, sqlite3explorer (www.sqlite.org/contrib). Afaik, it should import access ok.
> -----Original Message----- > From: RAY BORROR [mailto:[EMAIL PROTECTED] > Sent: Monday, March 28, 2005 9:54 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Exporting MS Access MDB into SQLite > > SQLite Users, > > I started to export an Access MDB file into a DB file that > was created with SQLite. > > I was using the Visual Basic, Visual Data Manager tool to > export tables to the SQLite DB using the SQLite ODBC driver. > > The first table went OK. > All other tables after that came up with the following error: > VisData > The following Error occurred > OBDC-call failed > Number 3146 > > If I create a new DB in SQLite, I am able to export one table > without a problem. > It doesn't seem to matter which table it is. > > Please review and advise of any possible solutions. > > > Thanks, > > Ray Borror > >
