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

2005-09-02 Thread Nick Jones
oop > > > >On Error Resume Next ' This is my solution to make > sure that the > >recordset is always closed, _ > > without the errorhandling there > >occurs an error when you use a query _ > > that doesn't

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 ther

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

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