Re: Use MySQL with Microsoft Office
From: Patrick Connolly Somewhere about Wed, 09-Mar-2005 at 03:02PM +0100 (give or take), Jigal van Hemert wrote: | From: Curtis Maurand | Using ODBC, however, you can link Access tables to MySQL tables and use | Access as the front end to MySQL. It works very nicely. | | Using ODBC you can access MySQL from OpenOffice.org (which has an | Access-like frontend built in), using ODBC and MS Jet engine (standard with | recent Windows versions) you can access and edit Access databases (*.mdb) | with OpenOffice.org. but only with Windoze, is it not? I assume it's dependent on the OS having the Jet engine. I'd be very interested to know if anyone has done an equivalent to that in Linux. Google is wonderful in this regard: linux/odbc/mdb: http://bryanmills.net:8086/archives/2003/11/microsoft-access-database-using-linux-and-php/ linux/odbc/mdb/openoffice.org: http://www.oooforum.org/forum/viewtopic.phtml?t=17403 ...and the rest at... http://www.google.com/search?num=100hl=enlr=newwindow=1safe=offq=linux+odbc+mdb+openofficebtnG=Search Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
Using ODBC, however, you can link Access tables to MySQL tables and use Access as the front end to MySQL. It works very nicely. Curtis Martijn Tonies said: Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Alternatively, you could switch to MS Access, which is very well supported by Microsoft Office. :-) mmhhh MySQL Vs. Access MS... just a little be different :-))) Yes, very :-) So is MS Office and OpenOffice :-) -- Martijn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
From: Curtis Maurand Using ODBC, however, you can link Access tables to MySQL tables and use Access as the front end to MySQL. It works very nicely. Using ODBC you can access MySQL from OpenOffice.org (which has an Access-like frontend built in), using ODBC and MS Jet engine (standard with recent Windows versions) you can access and edit Access databases (*.mdb) with OpenOffice.org. Anyway, there are always multiple solutions for a problem and the original poster managed to get MS Publisher to do a mailmerge with MySQL data. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
Somewhere about Wed, 09-Mar-2005 at 03:02PM +0100 (give or take), Jigal van
Hemert wrote:
| From: Curtis Maurand
| Using ODBC, however, you can link Access tables to MySQL tables and use
| Access as the front end to MySQL. It works very nicely.
|
| Using ODBC you can access MySQL from OpenOffice.org (which has an
| Access-like frontend built in), using ODBC and MS Jet engine (standard with
| recent Windows versions) you can access and edit Access databases (*.mdb)
| with OpenOffice.org.
but only with Windoze, is it not? I assume it's dependent on the OS
having the Jet engine. I'd be very interested to know if anyone has
done an equivalent to that in Linux.
--
___ Patrick Connolly
{~._.~}
_( Y )_ Good judgment comes from experience
(:_~*~_:) Experience comes from bad judgment
(_)-(_)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
From: Tom Crimmins On Monday, March 07, 2005 23:03, GH wrote: Greetings, I would like to know if it is possible to do a mail merge in Microsoft Office with a mySql database as the source? Thanks You can use install MyODBC, set up a DSN, and then use this in Office. http://dev.mysql.com/downloads/connector/odbc/3.51.html This article may also be useful for you to setup the MS Office side: http://support.microsoft.com/default.aspx?scid=kb;en-us;181926 Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Alternatively, you could switch to MS Access, which is very well supported by Microsoft Office. :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
Does Open Office have a MSPublisher like program? On Tue, 8 Mar 2005 12:43:01 +0100, Jigal van Hemert [EMAIL PROTECTED] wrote: From: Tom Crimmins On Monday, March 07, 2005 23:03, GH wrote: Greetings, I would like to know if it is possible to do a mail merge in Microsoft Office with a mySql database as the source? Thanks You can use install MyODBC, set up a DSN, and then use this in Office. http://dev.mysql.com/downloads/connector/odbc/3.51.html This article may also be useful for you to setup the MS Office side: http://support.microsoft.com/default.aspx?scid=kb;en-us;181926 Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
For the answer to that question, you might just want to go see for yourself. http://www.openoffice.org/ Steve At 08:16 AM 3/8/2005, you wrote: Does Open Office have a MSPublisher like program? On Tue, 8 Mar 2005 12:43:01 +0100, Jigal van Hemert [EMAIL PROTECTED] wrote: From: Tom Crimmins On Monday, March 07, 2005 23:03, GH wrote: Greetings, I would like to know if it is possible to do a mail merge in Microsoft Office with a mySql database as the source? Thanks You can use install MyODBC, set up a DSN, and then use this in Office. http://dev.mysql.com/downloads/connector/odbc/3.51.html This article may also be useful for you to setup the MS Office side: http://support.microsoft.com/default.aspx?scid=kb;en-us;181926 Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
From: GH Does Open Office have a MSPublisher like program? I'm not familiar with Publisher, but I gues that it is supposed to help you make publications in a kind of desktop pulishing way. In the article at http://www.newsforge.com/article.pl?sid=04/10/04/150207 the author compares Writer (the wordprocessing part of OpenOffice.org) with Adobe's Framemaker. Maybe that will help you a bit. It's worth mentioning that the current version OpenOffice.org 1.1.4 will soon be replaced by a major upgrade as the 2.0 beta has recently become available. On http://www.openoffice.org you can read all about the new features in this release. I use both OpenOffice.org and MS Office and both have their pros and cons. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Use MySQL with Microsoft Office
I know that this is a little off topic, but if you want a real Desktop Publishing Suite, try Adobe (InDesign, specifically). They cannot do MailMerges like in OpenOffice or M$, but it's much easier to use than M$ and looks a lot more professional. As a side note, OpenOffice, as of 1.1.2, does not have a Publisher type equivalent. It also does not have an Access equivalent, hence MySQL interoperability. J.R. -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:59 AM To: GH Cc: mysql@lists.mysql.com Subject: Re: Use MySQL with Microsoft Office From: GH Does Open Office have a MSPublisher like program? I'm not familiar with Publisher, but I gues that it is supposed to help you make publications in a kind of desktop pulishing way. In the article at http://www.newsforge.com/article.pl?sid=04/10/04/150207 the author compares Writer (the wordprocessing part of OpenOffice.org) with Adobe's Framemaker. Maybe that will help you a bit. It's worth mentioning that the current version OpenOffice.org 1.1.4 will soon be replaced by a major upgrade as the 2.0 beta has recently become available. On http://www.openoffice.org you can read all about the new features in this release. I use both OpenOffice.org and MS Office and both have their pros and cons. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
Thank you all for your responses. The reason that I am currently asking about Publisher is that i do certificates for programs that my organization runs and I am able to in publisher mail merge the Proper Names of both the recipients and signatories onto the certificate plus print the wording, graphics and other content all at once. with out having to do 2-3 passes through the printer ... a great time saver when doing 200 certificates I have the myODBC installed but can not get Publisher XP's mail merge to get the data. On Tue, 08 Mar 2005 10:11:03 -0500, J.R. Bullington [EMAIL PROTECTED] wrote: I know that this is a little off topic, but if you want a real Desktop Publishing Suite, try Adobe (InDesign, specifically). They cannot do MailMerges like in OpenOffice or M$, but it's much easier to use than M$ and looks a lot more professional. As a side note, OpenOffice, as of 1.1.2, does not have a Publisher type equivalent. It also does not have an Access equivalent, hence MySQL interoperability. J.R. -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:59 AM To: GH Cc: mysql@lists.mysql.com Subject: Re: Use MySQL with Microsoft Office From: GH Does Open Office have a MSPublisher like program? I'm not familiar with Publisher, but I gues that it is supposed to help you make publications in a kind of desktop pulishing way. In the article at http://www.newsforge.com/article.pl?sid=04/10/04/150207 the author compares Writer (the wordprocessing part of OpenOffice.org) with Adobe's Framemaker. Maybe that will help you a bit. It's worth mentioning that the current version OpenOffice.org 1.1.4 will soon be replaced by a major upgrade as the 2.0 beta has recently become available. On http://www.openoffice.org you can read all about the new features in this release. I use both OpenOffice.org and MS Office and both have their pros and cons. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Use MySQL with Microsoft Office
If Publisher XP's mail merge can find data in ACCESS try linking the tables into an ACCESS database and then tying Publisher to the ACCESS database. Sounds klunky but it might work. -Original Message- From: GH [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:37 AM To: J.R. Bullington Cc: mysql@lists.mysql.com Subject: Re: Use MySQL with Microsoft Office Thank you all for your responses. The reason that I am currently asking about Publisher is that i do certificates for programs that my organization runs and I am able to in publisher mail merge the Proper Names of both the recipients and signatories onto the certificate plus print the wording, graphics and other content all at once. with out having to do 2-3 passes through the printer ... a great time saver when doing 200 certificates I have the myODBC installed but can not get Publisher XP's mail merge to get the data. On Tue, 08 Mar 2005 10:11:03 -0500, J.R. Bullington [EMAIL PROTECTED] wrote: I know that this is a little off topic, but if you want a real Desktop Publishing Suite, try Adobe (InDesign, specifically). They cannot do MailMerges like in OpenOffice or M$, but it's much easier to use than M$ and looks a lot more professional. As a side note, OpenOffice, as of 1.1.2, does not have a Publisher type equivalent. It also does not have an Access equivalent, hence MySQL interoperability. J.R. -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:59 AM To: GH Cc: mysql@lists.mysql.com Subject: Re: Use MySQL with Microsoft Office From: GH Does Open Office have a MSPublisher like program? I'm not familiar with Publisher, but I gues that it is supposed to help you make publications in a kind of desktop pulishing way. In the article at http://www.newsforge.com/article.pl?sid=04/10/04/150207 the author compares Writer (the wordprocessing part of OpenOffice.org) with Adobe's Framemaker. Maybe that will help you a bit. It's worth mentioning that the current version OpenOffice.org 1.1.4 will soon be replaced by a major upgrade as the 2.0 beta has recently become available. On http://www.openoffice.org you can read all about the new features in this release. I use both OpenOffice.org and MS Office and both have their pros and cons. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
Il giorno mar, 08-03-2005 alle 13:46 +0100, Martijn Tonies ha scritto: Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Alternatively, you could switch to MS Access, which is very well supported by Microsoft Office. :-) mmhhh MySQL Vs. Access MS... just a little be different :-))) Regards Paolo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
I think I got it working I am printing out the records that I need... a bit of a 2 stepper but nice since I can store the queriy since that can not be done just yet in MySql On Tue, 08 Mar 2005 23:47:09 +0100, dixie [EMAIL PROTECTED] wrote: Il giorno mar, 08-03-2005 alle 13:46 +0100, Martijn Tonies ha scritto: Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Alternatively, you could switch to MS Access, which is very well supported by Microsoft Office. :-) mmhhh MySQL Vs. Access MS... just a little be different :-))) Regards Paolo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Alternatively, you could switch to MS Access, which is very well supported by Microsoft Office. :-) mmhhh MySQL Vs. Access MS... just a little be different :-))) Yes, very :-) So is MS Office and OpenOffice :-) -- Martijn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Use MySQL with Microsoft Office
On Monday, March 07, 2005 23:03, GH wrote: Greetings, I would like to know if it is possible to do a mail merge in Microsoft Office with a mySql database as the source? Thanks You can use install MyODBC, set up a DSN, and then use this in Office. http://dev.mysql.com/downloads/connector/odbc/3.51.html -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
