Hi! Yes, it's possible. Export your Access data to standard csv files, and then use mysqlimport with appropriate parameters to import the csvs into MySQL. The MySQL manual has excellent guidance on using mysqlimport or LOAD DATA INFILE statements (which can do the same as mysqlimport).
Iikka On Tue, 26 Nov 2002, Steve Jackson wrote: > Is it possible to export data from MS Access into MySQL? > If so how? > I have a huge amount of data that will take weeks to input and I've > convinced my boss to use MySQL rather than any other DB because of it's > compatibility with PHP. However I (probably hastily) *assumed* that > there would be a way to export the data. > Any ideas? > > Steve Jackson > Web Developer > Viola Systems Ltd. > http://www.violasystems.com > [EMAIL PROTECTED] > Mobile +358 50 343 5159 > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > ======================================== Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
