search find link to a value

[lintow]

I have a datbase that has 4 fields firstname, lastname, ID and link

I want to search a person and get results of there links in that database.

The field (link) has a value that points to an excel file.

So when I search that person I get a value that should point to an excel file.

And I would like to download that excel file from the browser.

I know you can link a excel file to anything.
but for my case there will be multiple excel files. So I want to search for the person that has an excel file and then dwonload it.

Can this be done. Does anyone have an example.

 

[lintow]

I'm not sure what you mean.
To test:
Where should I save the excel file

Then I should hyper link the excel file to the database by using Access. so it points to the excel file.

 

[lintow]

thanks man... it works.
Now I can create a search off all the people that have an excel file.

And be able to download them.

This is cool

 

[steven290]

you should save all your excel files here,
make a folder under the cnrweb folder called files

C:/Inetpub/

http://wwwroot/cnrweb/files/

then try this in your web browser

http://localhost/cnrweb/files/282423_L.xls

if that works


save this part in to your db 282423_L.xls then write your asp like this

response.write "<a href=""files/"&Recordset1("excel_two")&""">test</a>