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
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
/package/Spreadsheet_Excel_Writer (
*http://pear.php.net/package/Spreadsheet_Excel_Writer ) and it does
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
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
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
--- 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 think that you
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 export the values into
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
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 values in an Excel sheet from MySQL
--- J.R. Bullington
--- 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 that you can export the values into
10 matches
Mail list logo