PlaneDisaster.NET

Any good to you?

Hi

I have uploaded a file here
https://sourceforge.net/tracker/index.php?func=detail&aid=2539963&group_id=175298&atid=872673

It's pretty trivial, but feel free to make use of this with attribution.
At the worst, it provides a good starting point on which you can tweak the
statements to suit your purposes.

Thanks
Tom

Tom,

Any progress on this? Do you have partially working code. If so I will
look for a way to make the interger test work. Of course I would eventually
include the resulting code in PlaneDisaster.NET with proper attribution.

I have started a little work on this for my own project.

Something to be wary of is when you get the database schema via
GetSchema("Columns"), the "nullable" values don't seem to be right for
integers (most importantly on primary key fields) and I don't seem to be
able to find another way to fetch this information.

Therefore, it seems impossible to generate a valid CREATE TABLE statement
(solely?) from the information from GetSchema().

Anyone else got a solution to this in the works?

Hey,

Try the AccessToSQLite application that comes with plane-disaster.net. It
works for all databases I tested it on. If it doesnt work on yours send me
the error and if possible and small the auctual database. Reporoducing the
bug in a smaller database also works. Also please feel free to contact me
at zippy 1981 at google mail dot com with requests.

Logged In: NO

This would be great. I too want to move an access table into an sqlite
table without having to re-invent the wheel.