By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,181 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,181 IT Pros & Developers. It's quick & easy.

ADO: importing Excel data while it is already open by another user...

P: n/a
Is there a parameter to set to allow opening Excel file read only while
it is already open by another user?

I've tried the .mode setting in my connection string to adModeRead, but
it still won't allow me to read data from the spreadsheet. I get the
typical "File is opened exclusively by another user" error message.
Any input would be greatly appreciated!

Feb 2 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.