sql Lite help! - "database disk image is malformed!"

[cosmic]

I've exported a table from an access database into a delimted text and then imported into sql lite data browser and saved as a .db. The code i've used to open the database is as follows:

sDatabaseFile = _SourceFolder .. "\\AutoPlay\\Docs\\blah.db";
db = SQLite.Open(sDatabaseFile);
nLastError = Application.GetLastError();
if nLastError ~= SQLite.OK then
Dialog.Message("Error Opening File", SQLite.GetLastErrorString());
end

Upon preview/build I get the error "database disk image is malformed!"

Where did I go wrong?

[Worm]

What version of the SQLite Browser did you use?

I had to drop back to an older version (1.1) to create databases that were compatible with the SQLite plugin.

[cosmic]

Hey Worm...I'm using V 1.2.1. Do you know where I can download the older version?

[Worm]

http://sourceforge.net/project/showfiles.php?group_id=87946

[stickck]

i had the same problem as Worm. version 1.2.1 only make version 3 SQLite databases. i thought i was doing something wrong too. i messed with it for 4 hours!

[Worm]

Sorry about that... It never even crossed my mind to post that you needed to get the older version.

[cosmic]

it worked

Thanks very much for your help...It's reading the db now. I'm a bit of a rookie at this so I'm sure I'll be running into some other glitches.

[cosmic]

importing another table...

am importing a table (.csv) that has about 20000 records into the sqlite browser but it seems to hang. Has anyone also had this problem...any suggestions?

[Derek]

I did the same thing with about 7100 records and it seemed to hang.
At first it was fine, then it seemed to hang but it would appear to be doing something .. then eventually it was doing nothing. I figured it had lost it!
Cant remember how long I waited but i finally gave up and quit the program. On re-opening, all records had been imported which suggests the problem is more along the refresh stage not the importing.

[cosmic]

No such luck.

I left it for a while and on reopening I had nothing. Are there any other ways of exporting Access tables into sqlite??

I know I can try splitting up the tables but I'd rather do that as a last resort.