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
MyODBC MS Word MS Query
Hello ! I got MS Query working, but only in interactive mode. I tried to record the Word activities to following makro: -snip --- snap - ActiveDocument.MailMerge.OpenDataSource Name:=, ConfirmConversions:= _ False, ReadOnly:=False, LinkToSource:=False, AddToRecentFiles:=False, _ PasswordDocument:=, PasswordTemplate:=, WritePasswordDocument:=, _ WritePasswordTemplate:=, Revert:=False, Format:=wdOpenFormatAuto, _ Connection:= _ DSN=rasql;DB=rasql;SERVER=www.fds.local;UID=avani;PWD=avani;PORT=;OPTION=16 384;STMT=; _ , SQLStatement:= _ SELECT adressen_0.adrnr, adressen_0.searchfield, adressen_0.name, adressen_0.name1, adressen_0.strasse, adressen_0.plz, adressen_0.ort, adressen_0.postfach, adressen_0.plzpostfach, adressen_0.telefon1, adressen_0.telefon2, adressen_0.telefon3, adressen_0. _ , SQLStatement1:= _ telefon4, adressen_0.telefon5, adressen_0.ansprechcode, adressen_0.ansprechname, adressen_0.vorname, akten_0.intref, akten_0.akte, akten_0.sb, beteiligte_0.intref, beteiligte_0.adrnr, beteiligte_0.typ, beteiligte_0.typindex FROM adressen adressen_0, akte -snip --- snap - But it does not work. I always get the error 5922, Word could not open Datasource. can anybody help? rgds, 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 !?!?!
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: Newbie: MS Word + MyODBC + MySQL
Hello Mr.Venu, yes, of course, I took a look at it and I checked this out. It was quite useable for mass-mailings, but not for single letters. e.g. My database contains a lot of adresses. I created a dialogbox, where I enter a name and now the corresponding adress will be looked up in th DB. now if mysql returned only one row, a *.DOT document is loaded and I cut and past each part of the adress from my hidden SQL result into the letterhead. Problem is, that I have to use a second document for keeping the SQL-Result and - which is a larger Problem - I cannot update any DB records. regards, Felix - Original Message - From: Venu [EMAIL PROTECTED] To: Felix Schepmann [EMAIL PROTECTED] Sent: Saturday, January 26, 2002 8:10 PM Subject: RE: Newbie: MS Word + MyODBC + MySQL Hi, -Original Message- From: Felix Schepmann [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 26, 2002 12:21 AM To: [EMAIL PROTECTED] Subject: Newbie: MS Word + MyODBC + MySQL Hi There ! I am quite new to this MyODBC topic, though I am used to create Perl programs connecting to MySQL DBs. Currently I am able to fetch rows from the DB via MyODBC and show them in a blank document as a table. Usually this is how I add data into my documents (like invoices, etc.): I open a new document, get the data into a blank table, get the contents of the table and then copy and paste the data into my document. Is there a better way, to get the data from the DB, e.g. using the DB directly as a datasource? Is there a way how I can update the DB with new data, e.g. write some kind of front-end within Word's VB ? IS there a FAQ for all my Word-questions? Did u had a time to look into the following section of the manual under 'WORD'. http://www.mysql.com/doc/M/y/MyODBC_clients.html Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - 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
Newbie: MS Word + MyODBC + MySQL
Hi There ! I am quite new to this MyODBC topic, though I am used to create Perl programs connecting to MySQL DBs. Currently I am able to fetch rows from the DB via MyODBC and show them in a blank document as a table. Usually this is how I add data into my documents (like invoices, etc.): I open a new document, get the data into a blank table, get the contents of the table and then copy and paste the data into my document. Is there a better way, to get the data from the DB, e.g. using the DB directly as a datasource? Is there a way how I can update the DB with new data, e.g. write some kind of front-end within Word's VB ? IS there a FAQ for all my Word-questions? regards, 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