Inserting MS Access data into Excel spreadsheet in VB form
This is a multi-part message in MIME format.
------=_NextPart_000_01BC5D32.C4848B60
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Quote:
> >I'm having a hell of a time trying to populate a blank spreadsheet
> >object on a VB 5.0 form with data from an external Access database.
> >Populating a DBGrid object with the same data is easy, but how does
> >one go about populating an OLE Excel spreadsheet object?
Cameron,
There is a MS KB article that covers this:
http://www.microsoft.com/kb/articles/q113/8/99.htm
This is for VB3 but might answer some of your questions.
--
Marcos Mello
All Spammers should die of Gonorrhea and rot in hell.
(To E-Mail me, remove SPAM from my E-Mail address)
------=_NextPart_000_01BC5D32.C4848B60
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<html><head></head><BODY bgcolor=3D"#FFFFFF"><p><font size=3D2 =
color=3D"#000000" face=3D"Arial">> >I'm having a hell of a time =
trying to populate a blank spreadsheet<br>> >object on a VB 5.0 =
form with data from an external Access database.<br>> >Populating =
a DBGrid object with the same data is easy, but how does<br>> >one =
go about populating an OLE Excel spreadsheet =
object?<br><br>Cameron,<br><br>There is a MS KB article that covers =
this:<br>http://www.microsoft.com/kb/articles/q113/8/99.htm<br>This is =
for VB3 but might answer some of your questions.<br>-- <br>Marcos =
Mello<br><br>All Spammers should die of Gonorrhea and rot in =
hell.<br><br>(To E-Mail me, remove SPAM from my E-Mail =
address)<br><br><br><br></p>
</font></body></html>
------=_NextPart_000_01BC5D32.C4848B60--
