Re: Suggestion?
| From: | Chris Adams | Date: | Thu, 31 Aug 2000 21:53:46 +0000 |
| Subject: | Re: Suggestion? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2538@lists.php.net to get a copy of this message | ||
> So is there any way I can use MSAcess as a client from our workstation to
> view the data from the mySQL.?? or any other option. I major thing we need
> is to print out labels for our newsletter.
Two options:
Install the MyODBC driver.
Create an ODBC DSN for the MySQL database
Create a new Access database and use the Link Tables function to include
the MySQL tables:
Right click in the tables tab of your database and choose "Link
Tables".
It'll popup a standard file open dialog, but when you select ODBC in
the file types, it'll be replaced with a standard ODBC DSN selection dialog.
(This is supposed to be easy to use?)
Once you've selected the DSN, it will show you the list of available
tables.
This will give you mostly transparent access.
If for some reason you can't use ODBC, you could write a page which would
generate CSV which can be imported, but it's kludgey.