[thelist] mysql to ms word for merge letter
Adrian Fischer
adrian at logo-logic.com
Wed Apr 18 04:48:50 CDT 2001
Thanks Joe...does it matter that my db is hosted somewhere else?
*Theoretically* are you saying I can use the ODBC to dynamically link my
word document on my win_pc to my db on the internet (I have permanent cable
connection) or was that just wishful thinking on my part? Or are you saying
I can create a CSV file on the server then link to that...am I sounded as
though I don't know what I'm talking about (for very good reason)? If so
would there be any chance of taking a peek at he php you used?
Thanks
Adrian Fischer
> Adrian Fischer wrote:
> > Thought it would be worth asking before I try and do it myself....has
anyone
> > done anything like getting the names and addresses etc from a mysql db
and
> > saving them into a delimited file for use in a ms word document as a
merge
> > file?
> >
> > Just thought Id ask...tips..pointers...code ;-)
>
> I have 2 parts of the equation, maybe...
>
> I have created explicit CSV output pages with PHP+MySQL, saved them, then
> imported them into the Word for Mac ('98). I have added MySQL datasources
> with the MySQL ODBC Driver to a WinNT box.
>
> *Theoretically* you should be able to:
> - add an ODBC driver for MySql to your Windows box
> - use that as a datasource for your merge file
> (Windows help was pretty clear on how to use merged
> data, I'd read that part of the help section *carefully*)
>
> I got the mysql odbc drivers from the mysql site --
> http://www.mysql.com/downloads/api-myodbc.html
>
> Best,
> Joe <http://artlung.com/>
More information about the thelist
mailing list