ETL and Data Integration tools - Modern ETL software for everyone

Is there a way to access a read only excel file ? The intent is to take the values from the file and put them into a sql server table, which can be done, if I manually create a copy of the file (then the software has exclusive access to the file).

Thanks

Can't give a definite answer to your question
I will speak with development team about it

Mike

To be be honest I do not understand what the problem is.

Created new excel file
set attribute to read only
was able and process both excel 2003and 2007 files
No problems what so ever

Mike

when the excel file was set as read only we were unable to see the columns in the spreadsheet to develop the etl process.

Well in this case if you want to get help answer all following questions

www.dbsoftlab.com/forum/how-to-get-help-today.html

Mike