Re: Once more: MS Word MyODBC !?!?!
Hi folks, hi butch, yes, I do have MS query installed, but where to start? Is there a FAQ or HOWTO or just some sample-scripts? I just need the first steps, then I think I can walk alone ... rgds, Felix. - Original Message - From: Butch Bean [EMAIL PROTECTED] To: Felix Schepmann [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 7:39 PM Subject: RE: Once more: MS Word MyODBC !?!?! Yes, using MS Query which comes with Office ODBC must be installed and working with a DSN set to you MySQL database then... See if you have MSQuery installed... if you do the file name is MSQRY32.EXE in your Office directory. If MSQuery is not installed, find your Office 2k CD and run setup. You should be able to click add/change installed options. In Office tools find MS Query and pick Run from My Computer and then click Update Now. Butch -Original Message- From: Felix Schepmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 1:06 PM To: [EMAIL PROTECTED] Subject: Re: Once more: MS Word MyODBC !?!?! Hello Folks, oncemore I post this question: Is it possible to update data from Microsoft Word useing MyODBC? Is there any other way to update data from MS Word? Is here a VB Scripting Guru who can help me? cheers, Felix. (keywords: database, table, sql) :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Once more: MS Word MyODBC !?!?!
First things first... I included the links to MySQL.com for the ODBC Drivers (Win2k/XP or Win98). I am running Win2k and XP Pro so I know it works well with them. Make sure you run setup.exe from the directory you unzipped the files. The last step for install on the ODBC is setting up a DSN: Find Add a new (User/System) DSN (may be under system or user DSN Tab) In the driver box select 'MySQL' and click finish Enter 'my_odbc_test' in Windows DSN name Enter the IP or host name for the MySQL Server Enter the database name where the address 'stuff' is User...password... etc Click on Use compressed protocol Click OK Save/Apply/OK your way out of the ODBC screens Next we need to see if you have MSQuery installed... if you do the file name is MSQRY32.EXE in your Office directory. (Check) If MSQuery is not installed, find your Office 2k CD and run setup. You should be able to click add/change installed options. In Office tools find MS Query and pick Run from My Computer and then click Update Now. Start Word from a blank new document go to Tools - Mail Merge Click Create -Form Letter Click Get Data -Open Data Source Click MS Query (Alt+Q) Select my_odbc_test from the list Select the data tables to grab data from MySQL Select conditions to select the data and the sort order Select Return Data to MS Word There will now be a new toolbar in Word Use the Insert Merge Field button to add MySql fields to your document. The button next to Insert Word Field will toggle data view over field view (try it after adding a merge field to the document) Good luck Butch ODBC Win98 http://www.mysql.com/Downloads/MyODBC/myodbc-2.50.39-win95.zip ODBC WinNT/XP http://www.mysql.com/Downloads/MyODBC/myodbc-2.50.39-nt.zip Mail Merge Stuff for Word and VBA http://msdn.microsoft.com/library/en-us/dnovba00/html/MailMergePartI.asp http://msdn.microsoft.com/library/en-us/dnovba00/html/MailMergePartII.asp -Original Message- From: Felix Schepmann [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 4:38 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Once more: MS Word MyODBC !?!?! Hi folks, hi butch, yes, I do have MS query installed, but where to start? Is there a FAQ or HOWTO or just some sample-scripts? I just need the first steps, then I think I can walk alone ... rgds, Felix. - Original Message - From: Butch Bean [EMAIL PROTECTED] To: Felix Schepmann [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 7:39 PM Subject: RE: Once more: MS Word MyODBC !?!?! Yes, using MS Query which comes with Office ODBC must be installed and working with a DSN set to you MySQL database then... See if you have MSQuery installed... if you do the file name is MSQRY32.EXE in your Office directory. If MSQuery is not installed, find your Office 2k CD and run setup. You should be able to click add/change installed options. In Office tools find MS Query and pick Run from My Computer and then click Update Now. Butch -Original Message- From: Felix Schepmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 1:06 PM To: [EMAIL PROTECTED] Subject: Re: Once more: MS Word MyODBC !?!?! Hello Folks, oncemore I post this question: Is it possible to update data from Microsoft Word useing MyODBC? Is there any other way to update data from MS Word? Is here a VB Scripting Guru who can help me? cheers, Felix. (keywords: database, table, sql) :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Once more: MS Word MyODBC !?!?!
Hi Butch, I included the links to MySQL.com for the ODBC Drivers (Win2k/XP or Win98). I am running Win2k and XP Pro so I know it works well with them. Make sure you run setup.exe from the directory you unzipped the files. The last step for install on the ODBC is setting up a DSN: Next we need to see if you have MSQuery installed... if you do the file name is MSQRY32.EXE in your Office directory. (Check) I have got this all... Start Word from a blank new document go to Tools - Mail Merge Click Create -Form Letter Click Get Data -Open Data Source Click MS Query (Alt+Q) Select my_odbc_test from the list Select the data tables to grab data from MySQL Select conditions to select the data and the sort order Select Return Data to MS Word That's the way it works fine for me also, but i cannot automate this in a macro? Perhaps I cannot start MS Query from the macro, or at least I do not know how to ? There will now be a new toolbar in Word Use the Insert Merge Field button to add MySql fields to your document. The button next to Insert Word Field will toggle data view over field view (try it after adding a merge field to the document) usual stuff... okay, ODBC Win98 http://www.mysql.com/Downloads/MyODBC/myodbc-2.50.39-win95.zip ODBC WinNT/XP http://www.mysql.com/Downloads/MyODBC/myodbc-2.50.39-nt.zip great stuff, I downloaded it about 2 months ago... Mail Merge Stuff for Word and VBA http://msdn.microsoft.com/library/en-us/dnovba00/html/MailMergePartI.asp http://msdn.microsoft.com/library/en-us/dnovba00/html/MailMergePartII.asp This is really new to me, I will check this out today ! Thanks a lot Butch ! greets, Felix. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Once more: MS Word MyODBC !?!?!
Hello Folks, oncemore I post this question: Is it possible to update data from Microsoft Word useing MyODBC? Is there any other way to update data from MS Word? Is here a VB Scripting Guru who can help me? cheers, Felix. (keywords: database, table, sql) :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Once more: MS Word MyODBC !?!?!
Yes, using MS Query which comes with Office ODBC must be installed and working with a DSN set to you MySQL database then... See if you have MSQuery installed... if you do the file name is MSQRY32.EXE in your Office directory. If MSQuery is not installed, find your Office 2k CD and run setup. You should be able to click add/change installed options. In Office tools find MS Query and pick Run from My Computer and then click Update Now. Butch -Original Message- From: Felix Schepmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 1:06 PM To: [EMAIL PROTECTED] Subject: Re: Once more: MS Word MyODBC !?!?! Hello Folks, oncemore I post this question: Is it possible to update data from Microsoft Word useing MyODBC? Is there any other way to update data from MS Word? Is here a VB Scripting Guru who can help me? cheers, Felix. (keywords: database, table, sql) :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
