Cheers. Sorted very quickly using MySQL front. Good thing is I can use that to get the SQL and then cut and paste it to any DB I like which is PDG!
Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 > -----Original Message----- > From: FlashGuy [mailto:[EMAIL PROTECTED]] > Sent: 26. marraskuuta 2002 16:42 > To: MySQL General Mailing list; [EMAIL PROTECTED] > Subject: Re: Is it possible to export data from access to MySQL? > > > > Download MySQL-Font v2.5 > > This is what I used when I switched from Access to MySQL. > > Once installed just load MySQL-Front and click on > "Im-/Export" on the toolbar. Select ODBC Import. > > Viola! > > > > On Tue, 26 Nov 2002 16:37:45 +0200, 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 > > > > > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > --------------------------------------------------------------------- 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
