SQL data into an excel sheet

Results 1 to 2 of 2

Thread: SQL data into an excel sheet

  1. #1
    pmorales Guest

    Default SQL data into an excel sheet

    Is there a way to put data from a SQL database into an excel spreadsheet?

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL data into an excel sheet

    On the Microsoft support site there is a suggestion for this Do a search on Asp101 for Excel for the link. <BR><BR>1) You will need to create a fileobject and create a file on the server with a random file name.<BR><BR>2) For each column seperate the column by the Tab charecter<BR>3) for the next record add vbnewline<BR>4) save the file as .xls <BR><BR>This does not allow any formating and is sloppy if the data has the chr 10 and 13. <BR><BR>I can&#039;t find a better way of doing this myself<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts