Access database?

[Raindog]

I have a database made in Access. Can I convert that database to something I can use in AutoPlay Media Studio?

[eric_darling]

If you can find a way to get it into SQL Lite, then yes.

[Brett]

Your best bet might be to go from Access -> XML -> SQLite (you'll have to write your own import functions with the XML plugin). If you want to use the Access database directly, you could use the LuaCOM plugin to get the date through ADO's ActiveX interface, assuming you are familiar with ADO. The downside to this is that then your customers all need MDAC pre-installed which is a lot fo overhead. For a light-weight, self-contained solution the SQLite plugin would be the way to go.

[kpsmith]

If you can get the data into a LUA table you can convert over to a SQLite database real easy.

I went from Excel ---> Lua table in a text file --> to a SQLite Database

The same thing should work for access depending on how complex the database is.

Essentially I wrote a formula in excel to create the code needed for the lua table in the last column of the spreadsheet.

I then copy an pasted that column to a text (.lua) file that I'd load into and AMS app that essentially read the data from the table and converted it to the SQlite Database.

If you need an example let me know...

[Ted Sullivan]

Now *that* is good thinking! An excellent technique.

[coffeeworm]

Can more samples for Lua?
I don't know how to use Lua plug-in. ops

[csd214]

If you need an example let me know...

Yes, please. Should be most appreciated.

[kpsmith]

Did I volunteer for that? Sorry I swore off computers for the weekend. Quality time with the kids ...

Anyhow, here's an example.

Overview...

Created a spreadsheet called Sample.xls
Created a formula in the last column that creates the necessary LUA table structure
Copy and pasted the last column of data to a text file named Sample.lua

Now I run the AMS proggie and that loads the LUA table data to the table ImageTable
Then counts the # of records in the table
Then creates sample.db and loads the data in the SQLite database using a repeat loop until you get to the Total # of records

Hope this helps. All these files (sample.xls, sample.lua, sample.db are going into the CD ROOT folder.

Use the SQLite Database Browser.exe that Intrigued posted to view the database.

[Intrigued]

kpsmith...

Very nice!

Thank you for taking time out of your busy schedule to code and then share this excellent example.

I really appreciate everyone's support, suggestions here in the forums. Some humor and lots of good help, sharing are going on between these PHP, HTML pages!

Thank you again kpsmith!