[thelist] A bit off topic - Access DB

[Jay Greenspan]

There are a few utilities you can use, I recommend access_to_mysql, which
you can find here:

http://mysql.mirrors.netnumina.com/Downloads/Contrib/access_to_mysql.txt

The instructions in the file are pretty clear.


-j


On Sunday, November 18, 2001, at 11:49 PM, Roee Rubin wrote:

> Hello,
>
> I am a bit unfamiliar with Access DB so your help will be appreciated.
>
> I need to export a database and later import it into a mysql DB. The 
> problem
> I am having is that the file I am exporting has many \t and \n 
> characters
> embedded which basically screw up the exported file.
>
> MySQL Front has a feature that exports a complete table into a 
> collection of
> SQL statement which can later be imported. Is there anything similar in
> Access? What are my other options in transferring the data?