Re: Populate values in an Excel sheet from MySQL [SOLVED]

2005-09-02 Thread Nick Jones
return results > >('INSERT' e.g.). If there is a better way _ > > to close the connection, then > >let me know. > >If rs.State = adStateOpen Then rs.Close > >On Error Goto 0 > >cn.Close > > > >Set rs = Nothi

Re: Populate values in an Excel sheet from MySQL

2005-09-02 Thread inferno
om: Nick Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 08:23 PM To: mysql@lists.mysql.com Subject: Populate values in an Excel sheet from MySQL 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

RE: Populate values in an Excel sheet from MySQL

2005-09-02 Thread Arjan Hulshoff
et me know. If rs.State = adStateOpen Then rs.Close On Error Goto 0 cn.Close Set rs = Nothing Set cn = nothing <--End Code-->> HTH, Arjan. -Original Message- From: Nick Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 08:23 PM To: mysql@lists.mysql.com Subjec

Re: Populate values in an Excel sheet from MySQL

2005-09-01 Thread Nick Jones
--- 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

RE: Populate values in an Excel sheet from MySQL

2005-09-01 Thread J.R. Bullington
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

Re: Populate values in an Excel sheet from MySQL

2005-09-01 Thread Partha Dutta
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

RE: Populate values in an Excel sheet from MySQL

2005-09-01 Thread SGreen
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

RE: Populate values in an Excel sheet from MySQL

2005-09-01 Thread Nick Jones
--- "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

Re: Populate values in an Excel sheet from MySQL

2005-09-01 Thread JamesDR
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

RE: Populate values in an Excel sheet from MySQL

2005-09-01 Thread J.R. Bullington
easier. J.R. -Original Message- From: Nick Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 2:23 PM To: mysql@lists.mysql.com Subject: Populate values in an Excel sheet from MySQL Does anyone know if it is possible to populate values into an Excel spreadsheet from a

Populate values in an Excel sheet from MySQL

2005-09-01 Thread Nick Jones
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 Yahoo!? Tired of sp