Local Mysql Info

G

Greg Barnett

Hi,

I use php & mysql on a regular basis and im wondering how to go along
pulling information from the mysql database and populating a local access
database with the info?

Is it anything to do with ODBC?

any help (even the smallest of suggestions) would be great!

Greg
 
T

Tony Toews [MVP]

Greg Barnett said:
I use php & mysql on a regular basis and im wondering how to go along
pulling information from the mysql database and populating a local access
database with the info?

Is it anything to do with ODBC?
Click to expand...

Exactly. You need to install a MySQL ODBC driver on your system.
Then Access, Excel and any other ODBC compliant product can extract
data from your MySQL database.

No idea as to where to download such but I'm sure the official MySQL
website would have that info.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access for MySQL data reports only 5
How to configure the user and password for MySQL 2
Export Access Table to MySQL database using C# program 2
Access front end via ODBC to MySQL 2
VBA Code to Connect and Query a MySQL Table 12
Connecting to MySQL at Startup 4
add password to circumvent mysql connector pop-up 3
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2

Top