Connect to a mysql database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

moore82 - 28 Mar 2006 23:28 GMT

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

Reply to this Message

Jezebel - 29 Mar 2006 00:04 GMT

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.

> Hello,
>
[quoted text clipped - 15 lines]
>
> David

Reply to this Message

moore82 - 29 Mar 2006 11:02 GMT

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

> Read Help on how to use MailMerge to create a catalog.
>
[quoted text clipped - 20 lines]
> >
> > David

Reply to this Message

Jezebel - 30 Mar 2006 05:00 GMT

> 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.

Reply to this Message

moore82 - 30 Mar 2006 10:16 GMT

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*

> > Do you know the cose for connecting to the DB from a macro,
>
[quoted text clipped - 7 lines]
> 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.

Reply to this Message

David Sisson - 31 Mar 2006 15:42 GMT

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

Heres one.

http://groups.google.com/group/microsoft.public.word.vba.general/browse_thread/t
hread/4dfa9f71e12b4eaf/b1029b70edbc013c?q=mysql&rnum=3#b1029b70edbc013c

Reply to this Message

keith - 14 Apr 2006 02:02 GMT

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

Reply to this Message