Thanks very much. Works great. Roee -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Jay Greenspan Sent: Monday, November 19, 2001 6:24 AM To: thelist at lists.evolt.org Subject: Re: [thelist] A bit off topic - Access DB 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? --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !