Hello All,



I know you can store Excel files in a MS Access Database. How could I get

them there through an ASP interface?



I also want people to be able to click on a link to down load the files, but

everytime I link to an excel file, it opens in the browser. Is there away

around this?



-Thanks

Scott

...assuming you created an access object...



    objAccess.TransferSpreadsheet acImport, 8[excel version], "tableName",

"path-to-excel-file", False, ""



This should work for files on the same machine as the db...it converts them

into tables directly, the False means the 1st row is data, if they're field

names use True. Last param is cell/row range, empty is all.



For the second question, windows host scripts or activex on the client can

open an instance of excel instead of within the browser, but these would

need to be registered on the client to run.



tom mallard

seattle