what is the procedure to insert *.pdf, *.avi, *.jpg files into the d/b. I KNOW that it is better done by just placing links to those files but i wish to know how they are actually inserted into the database. what are the datatypes used in oracle, sql server and access . can anybody help me with the queries to create a table containing above 3 types of files, insert data ( i really wonder how it is done ) & show it back , or direct me to online resources and live examples<BR><BR>Thanx for your time.