Thanks to all for your help. I solved my problem the
quick and dirty way. Here's what I did:
1. Created my Excel spreadsheet to look the way I
wanted it, saved it as an XML spreadsheet.
2. Used PHP to pull the desired data from the MySQL
server on our iSeries machine.
3. PHP writes the XML data
Hi,
I had to do the same thing on a project and the problem was that if
you use CSV you will not be able to make a formated excel document.
I am using now *Spreadsheet_Excel_Writer
(
*http://pear.php.net/package/Spreadsheet_Excel_Writer ) and it does
everything I need, including format
Hello Nick,
This you can do with the MySQL ODBC Driver installed
(http://dev.mysql.com/downloads/connector/odbc/3.51.html). Further more
you need to activate Microsoft ActiveX Data Objects in the references.
You can use the following code:
<--Begin Code-->
Dim cn As ADODB.Connection
Dim rs As ADO
--- Partha Dutta <[EMAIL PROTECTED]> wrote:
> Nick Jones wrote:
>
> >--- "J.R. Bullington" <[EMAIL PROTECTED]>
> wrote:
> >
> >
> >
> >>Automatically populate??
> >>
> >>Not that _I_ know of, but of course there are
> those
> >>on this list that know
> >>much more than I.
> >>
> >>I do know
hope this helps a little!
J.R.
PS - Shawn FYI, if you copy and paste a tab into the replace with in
notepad, you can do it that way...
-Original Message-
From: Nick Jones [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 3:19 PM
To: mysql@lists.mysql.com
Subject: RE: Populate
Nick Jones wrote:
--- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
Automatically populate??
Not that _I_ know of, but of course there are those
on this list that know
much more than I.
I do know that you can export the values into tab
delimited format and then
import it into Excel.
I t
Nick Jones <[EMAIL PROTECTED]> wrote on 09/01/2005 03:18:39 PM:
>
>
> --- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
>
> > Automatically populate??
> >
> > Not that _I_ know of, but of course there are those
> > on this list that know
> > much more than I.
> >
> > I do know that you can ex
--- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
> Automatically populate??
>
> Not that _I_ know of, but of course there are those
> on this list that know
> much more than I.
>
> I do know that you can export the values into tab
> delimited format and then
> import it into Excel.
>
> I thi
Nick Jones wrote:
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do You
Automatically populate??
Not that _I_ know of, but of course there are those on this list that know
much more than I.
I do know that you can export the values into tab delimited format and then
import it into Excel.
I think that you may want to do this via ASP or PHP. It would make life a
lot e
10 matches
Mail list logo
