Database Conversion

[Kimera]

Hello all,

I have a question about databases. I am working on a project that has a .mdb file. I want to use the sql lite 3 object, i think, but how do I convert the current records, in to a new sql lite 3 object?

I have looked for an example but have not been able to find one. The best I can find is to export each table to a CSV. Is that my only option?

Thanks,
K

[Corentin]

If i'm not mistaken a .mdb file is an access database ?

If so, then you can probably create a dump of your database from access. You can probably choose which kind of dump you want : CSV (as you said), or probably SQL. This SQL should be compatible with SQlite 3

You might have to make some slight modifications to make it sqlite3 compatible, though. I use SQliteManager (a php script), which can also read MySQL statements, maybe this could help you too.

I never worked with .mdb and access, so excuse me if my post is useless

[Kimera]

Well its a microsoft database, hence the .mdb extention, but is normally edited in access but I don't use access. I use ADO and write what I need so thats what I did. It only took about 10 min. to write a script that pull the fields out I wanted and using live receiver I pulled it down and imported it in to a new DB I created with the sqllite object. This worked great as I had several cities dbs I had to deal with to make the new format. I will have to check to see if access, I use open office, its free, has an export for future ref.

Thanks for your input, you had it right but even if you didnot I give you credit for the reply, at least you gave me what you though i needed and you were right!

Thanks again,
K

[Corentin]

I don't know anything about .mdb files like i already said, but sqlite databases have an sqlite_master table which contains all the sql statements of its structure. You're probably looking for more than just your structure, but if not it could be interesting to search if mdb files use such a master table.

[Kimera]

No worries, I did not need all the data out of the mdb file, it was so messed up and had no real structure just a bunch of tables and bad indexing, so I was able to create the fake csv files using ASP, create the tables I wanted in sqllite and then I can save the file out to access the data as needed when the app is restarted. This way the client software can use the data it gets from each boot, downloaded as CSV files using Live Reciever, and run with the speed of sql on their end once they have the data and the clients who need the data dont have to querry the server but one time. Since they don't make updates I am in good shape.

If I wanted to update the main DB on the server all I would need to do is pass the data using Live Reciever. In fact I could have done this and left the server database an mdb file but that would not have been as much fun now would it!

MMF is such a great program and the people here are too. I can't tell you how many software packages I purchased for more money and got less, or no, support than we get from everyone at clickteam and this forum.

Thanks for all the input, though I found a workaround for my needs, your information got me thinking about some other things that I will check out when I get some time.

K