If there's only a couple of tables you could just export to CSV per table
(phpmyadmin makes this easy). Simple for the Access user to import.
Select... into outfile... is fine. See:
http://dev.mysql.com/doc/refman/5.1/en/select.html
************************************************************
D. Eric Chadbourne
Data Analyst
************************************************************
Alf Stockton <[EMAIL PROTECTED]>
12/29/2006 10:42 AM
To: mysql@lists.mysql.com
cc:
bcc:
Subject: MySQL export to csv
Can anyone tell me how to export a mysql db to a csv file suitable for
my client to import into his windows access program.
--
Regards,
Alf Stockton www.stockton.co.za
The abuse of greatness is when it disjoins remorse from power.
-- William Shakespeare, "Julius Caesar"
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
This message (including any attachments) contains information that
may be confidential to Koninklijke Ahold N.V. or its group entities.
If you are the intended recipient, you are authorized to use the
information only as expressly authorized by Ahold and must strictly
adhere to applicable security procedures, including without
limitation the following:
- You must protect files using the password and level of protection
in which the file was provided to you; and
- You may transmit files only as necessary for the task you are
assigned using secure systems and appropriate encryption means.
If you have received the message in error, please advise the sender
by reply e-mail, and destroy all copies of the original message
(including any attachments). Please direct any questions to the
sender of this message.
