Mysql > MS Access

Hello People,
Having followed the excellent tutorials here, I have managed to set up my db to get client info from a web form.
What I want to do now is load it into MS Access.
I have searched around and found a module called "importSQL" from www.netdive.com/freebies/importsql but have not had a lot of success with it.
Does anyone have any info/links they could post, or advise on how to do this.
I am using Access2000
Thank you in advance.

Tim

Have you set up the MySQL userid to allow remote connection via ODBC? Have you installed MyODBC drivers?

An alternative to importing the data to Access is set-up table links (assuming ODBC has been set-up).

To do this:
1. Right click in table section of Access
2. Select Link Tables
3. Scroll to the bottom of file types and select odbc
4. Select machine data source
5. Select database connection
6. Enter password and OK (MySQL connection)
7. Select tables from list.

You should now have direct connection to the remote MySQL database. You won't be able to alter table definitions but you will be able to manipulate data.

Andy J

Thanks for that Andy.
No at present myodbc is not installed, I will do that and get that working.
In the meantime is there a simple way to import the *.sql file that I dump into Access or even excel with out setting up mysql on my local machine.
I need to be able to make the information available off line to another who is running windoze and has even less knowlege than me!

In brief what I would like to do is dump the dB and import it into access/excel and save the file out and send it to another.
This would surfice until I get the odbc connection running.
I see lots of stuff about Access>mysql which is neat but not a lot on this topic.

Thanks in advance anyone.
Tim

You can do the following my MySQL

SELECT * INTO OUTFILE 'data.txt' FROM your_table;

That'll create a tab delimited file called data.txt. I'm sure you can import this into Access...

---John Holmes...

------------------
*************************************************************
* The manual can probably answer 90% of your questions...
*
* PHP Manual. www.php.net/manual
* MySQL Manual: www.mysql.com/documentation/mysql/bychapter
*************************************************************

Excellent, Thank You.
I am now reading the manual!
Tim