Hi,
I think is better to export your each table from Access to a .txt formatted
file...fields separated by ',' and end_of_line by ';'.It's better to avoid
Cr or CrLf.
Copy the .txt files into MySQL server host in a directory where MySQL have
reading rights.
And after this you can import in your MySQL tables using (...this can be a
way) LOAD DATA...
E.g:
LOAD DATA INFILE 'the_path_to_one_of_txt_files' INTO TABLE
one_of_table_to_load FIELDS TERMINATED BY ',' LINES TERMINATED BY ';';
This it should be work.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "mc 02" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 18, 2003 7:51 AM
Subject: Re: Connection ms access to mysql
> Hi Bob hall,
>
> I do apologize for being unclear in my previous message.
>
> To answer your question:
>
> >Does the MySQL server run on your FreeBSD system?
>
> Yes MySQL runs prefectly with my FreeBSD 4.6 system.
>
> > How are you trying to export your Jet tables? I assume that's
> what you mean when you refer to "files". If you actually want to
> put your mdb files on FreeBSD, then you should be asking the
> freebsd-questions list about Samba.
>
> Im still unsure how im exporting the tables. What i want to do is
> exporting all the tables in the mdb files to mysql database and i
> dont know how to go about it.
>
> Thanx
>
> p.s: I'm looking into Samba as u mentioned previously.
>
> Regards
> MC
> --
> __________________________________________________________
> Sign-up for your own FREE Personalized E-mail at Mail.com
> http://www.mail.com/?sr=signup
>
> Meet Singles
> http://corp.mail.com/lavalife
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
