Hi All,

I am having an Excel file(..abc.xls) with 'Submit' button on one of the Sheets. When User Clicks that button, I need to upload the entire excel file ( means the abc.xls file) which he is working into Sybase SQL Anywhere database table with blob column. I have defined a ODBC Driver to connect to Database.

My idea of doing it... save the existing excel file into some temp dir as abc1.xls and upload that file into database... and then delete that abc1.xls file. But I am not sure whether this is right way or there exist a better way of doing it.

Please guide me to complete this task... I am not so good at VBA Programming as of now.. Please provide me some sample code also.. if possible... or give me some book reference to learn thru.

Thanks in advance for all your help.

Thanks,
G S.