Connect to a mysql database

[moore82]

Hello,

I have a mySQL DB on my local computer (localhost) and it holds information
on many thousands of different products prices etc...

I also have a number of word files that I have to manually update with the
prices etc... every so often.

Therefore, this can lead to discrepancies. Is there a way to connect a mySQL
DB to Word 2003 using a macro and put data into certain places within the
document. I've never done anything like this with an office document so any
help would be great.

Thanks

David

 

[Jezebel]

Read Help on how to use MailMerge to create a catalog.

If that doesn't serve, then yes, you can create a macro that opens a
database, extracts information, and inserts it into the document.

 

[moore82]

Do you know the cose for connecting to the DB from a macro, and if so, how I
can place a certain bit of info into a diff field each time the Loop
reiterates?

Thanks for that

 

[Jezebel]

Do you know the cose for connecting to the DB from a macro,

Yes I do; I learnt it by reading the documentation and following the
examples provided.

and if so, how I

can place a certain bit of info into a diff field each time the Loop
reiterates?

If this is as far as you've got writing your specification, it would be
better if you didn't attempt the project at all.

 

[moore82]

Thank you Mr Jocky.

I must say that I haven't found many examples on the Internet, or in my
books, that's why I'm in forums asking for help.

Thanks for your constructive criticism *hmmmm*

 

[David Sisson]

I search for mysql in this group and found several pages of matches.

Heres one.

http://groups.google.com/group/micr...29b70edbc013c?q=mysql&rnum=3#b1029b70edbc013c

 

[keith]

Mysql.org distributes a myodbc driver that allows you to create odbc data
sources for mysql sources.