> I have a .mdb file which I need to import into MySQL. This needs to be
> done behind the scenes and with code. Can I use LOAD DATA INFILE where
> I use the .mdb file instead of a .txt file?
An "mdb" file isn't exactly the same as text, is it?
You might as well use MS Word as the source ;-)
> If not does anyone have any suggestions?
Use a datapump.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com