Hi..

I want to upload xls, doc files to Oracle through ASP. Can any one give any guidance on how to go about this ?


Vikas.

Hi Vikas,

  What exactly your requirement. How big those files(xls/doc)
How frequent you want to store.
Its better to save the filename in the database instead of full file contents.

Store the file name in the table and refer these files while retrieving.


--------------
Rajani

Rajani,

They are nearly 2-3 mb, however we can keep a limit of 5 mb. I am ok with keeping the files in the server, but then how to manage the files, if files are loaded with same name ?

Vikas,

IMO you can use a FKey that would differentiate each file, though they are of same name.

Can you explain on the table structure and what for these files are uploaded to DB, that would help in understanding this better.

Cheers!

_________________________
- Vijay G
Strive for Perfection