Excel to Mysql / Mysql to Excell Converters - help pleas

[mudman]

I would like to add a ton of spawns to the database. But it would be much faster to use Excel and then export to Mysql tables.

I found some nice software by Intelligent Converters
http://www.convert-in.com/xls2sql.htm
The demo is nice but will only do four reccords, it is really fast though to and from Excell in a snap.

Question is isn't there some open source or shareware 30day at least around like this

or should i just Use ODBC drivers, if so I am completely lost how those work with Excel.

Thanks, Mudman

[Lurker_005]

csv (comma seperated values) is a filetype that is importable and exportable to both apps pretty easily, read up on mysql and excell about it some. Not the most elegant way, but fairly simple.

with ODBC, you can get data from mysql pretty easy.... not positive about loading data back to it thought.

[vuke69]

The best way to do it is to write yourself a little input form in Access and have the tables linked directly to the MySQL db using ODBC.

Try googling for "convert access MySQL" and you will find a couple explanations on how to do it, its not that hard once you figure it out the first time.

You can also very easily export an existing access table to a MySQL table or vice versa.

Despite how much access sucks, it is nice to be able to use it as a quick and dirty front end for a "real" database.

If you need more help email me bvukich1@wi.rr.com

[Trumpcard]

Yea, I use it to link to mainframe db2 tables all the time just because it's just a pain in the butt having to access mainframe data through term sessions.