Celeste Suliin Burris wrote:
I'm a bit confused as to why you need to use ODBC. I just connect to the
remote MySQL server via the DBI when I'm using Perl. I have my Linux machine
running MySQL 5.0.
Hi Celeste -
I'm working on a program that will update a database throughout the day
and provide the customer with a spreadsheet of the results. I'd rather
have the customer be able to open the spreadsheet any time and get the
latest data rather than having to create a new spreadsheet each time the
data updates. I should be able to accomplish that by putting the ODBC
connections directly in the spreadsheet.
I have no problem doing the DBI connection from Perl, which is what I've
been doing for quite some time. What I'm after is a way to do the
connection from an Excel spreadsheet that has been written by
WriteExcel. The program is for multiple customers, so I want/need to be
able to write a spreadsheet that is for the particular customer. I might
be able to do this as an Excel template, also. That would be Plan B or C.
From: Mike Schienle <[EMAIL PROTECTED]>
Organization: Custom Visuals, LLC
Date: Wed, 07 Jun 2006 16:51:36 +0100
To: [email protected]
Subject: Spreadsheet::WriteExcel and ODBC
Hi all -
I need to write some Excel files with ODBC access to a MySQL database.
I've used Spreadsheet::WriteExcel in the past for writing formulas,
formatting, etc., with no problems, but the ODBC connection is new to
me. I tried it manually (just opening a blank spreadsheet and connecting
to a remote MySQL server) last night using Actual's ODBC client demo and
that worked fine. The WriteExcel docs are a bit vague [to me] on
connecting to an ODBC source, though.
Has anyone done this via Spreadsheet::WriteExcel? Do you mind passing
along a couple hints? Would this require any customer/client to have an
ODBC client on their system for this to work? If so, I may just go with
static data and have the customer pick up a new spreadsheet each time.
Also, as mentioned above I'm using Actual's ODBC client. Is there a
better client out there? Or an Open Source one that's competitive?
Thanks.
--
Mike Schienle
--
Mike Schienle
