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

2005-09-02 Thread Nick Jones
= 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 Subject: Populate values in an Excel

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

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 think that you

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 that you can export the values