[Techtalk] Re: MS Access --> mysql

[Phil Savoie]

Thank you Ladies and Gents for all of your input.  At least now I have 
something tangible to start from and with some kind of  game plan to follow.

Phil Savoie

On May 2, 2003 12:55, Ashima Saigal wrote:
> All,
>
> My boss had asked if there was a way to convert an ms access db to mysql.
> Not
> having dealt with databases before I couldn't give a qualified answer.  So
> I
>
> am calling on all those db experts out there to ask a few questions.
>
> 1.	Is it as simple as exporting in some sort of delimitied file and
> importing
> into mysql?
>
> 	-- that is one way to do it, probably most effective.
>
> 2. 	Has anyone ever tried to do this?
>
> 	-- not exactly, but ported from MS-ACCESS to MS-SQL or Filemaker Pro
> or FoxPro, etc.
>
> 3.	Were there any gotchas to look out for?
>
> 	-- Make sure you have relatively clean data, no sense porting bad
> data.
> 	-- Check your delimiter!
>
> 4.	Is msql relatively close to ms access in behaviour?
>
> 	-- MySQL is simply a database, Access is much more, it's an
> application environment.
> 	-- You'll need something to interface with the MySQL database (PHP
> perhaps, also could use Perl or Java)
>
> Good luck!
>
> Ashima Saigal
> ashima at npowermichigan.org
> http://www.npowermichigan.org
> 616-632-1020 (phone)
>
>
> _______________________________________________
> Techtalk mailing list
> Techtalk at linuxchix.org
> http://mailman.linuxchix.org/mailman/listinfo/techtalk