How do you display ASP results using Excel?

Answer by  bibi (57)

Create a System DSN called "pubs" as your local SQL Server,and use "pubs" as the default database. Use Notepad.exe to create a file called XlTest.asp

Answer by  gigo (1706)

If your results come from an asp page, it means, that the results are displayed on an html page. In that case you can copy all the data with CTRL A + CTRL C. Having changed to excel you can cut some headlines and footnotes. Now use the menu "extras, text in columns" to separate the text.