p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: Exporting db query results to Excel


Message #1 by giswim1@a... on Thu, 19 Jul 2001 21:02:44
Try:

http://support.microsoft.com/support/kb/articles/Q200/1/24.ASP

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: <giswim1@a...>
To: "Code Clinic" <proasp_codeclinic@p...>
Sent: Thursday, July 19, 2001 9:02 PM
Subject: [proasp_codeclinic] Exporting db query results to Excel


: When I export the results of a db query (Access 97) to Excel (2000), the
: cells are populated almost correctly.  However, for some cells, #VALUE is
: there instead of the correct text (the db fields are memo)  Does anyone
: know why this is?  I don't think it's a coding thing... maybe a limitation
: in Excel?  My code for populating the spreadsheet is below.
:
: Thanks!!
:
: >---MY CODE---<
: <%option explicit%>
: <%Response.Expires = 0%>
: <!-- #include file="adovbs.inc" -->
: <%'Set up Excel file
: Dim fso, fil1,strQuery, strType
: Dim row, col, objConn, objRS, ConnectionString
: row=1
: col=1
: Dim xlapp 'Excel App object
: Dim xlsheet1 'Excel Worksheet object

<snip>


  Return to Index