[thelist] A bit off topic - Access DB

[Scott Adamson]

the only thing i can suggest is to set up an odbc connection between mysql
and access, its probably the simplest most reliable method of getting your
data back in there intact

----- Original Message -----
From: "Roee Rubin" <webdesign1 at irubin.com>
To: "Thelist" <thelist at lists.evolt.org>
Sent: Monday, November 19, 2001 5:49 AM
Subject: [thelist] A bit off topic - Access DB


> 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?
>
> Thanks in advance.
>
>
>
> Roee Rubin
> roee at irubin.com
>
>
>
>
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>