Excel - Read-only

I created a system DSN for an Excel file and I have been using it for a
while. I can read from it as well as update it. (The Excel file
includes weekly updates to some records.)

Then I tried to create the same connection with an explicit connection
string. It opens the file fine, I can read from it and all. But when
I try to update it, it complains that the database is read-only. I am
using the connection string: "Driver=Microsoft Excel Driver
(*.xls);DBQ=excel-fle-path;Uid=;Pwd="

Is there a switch to include to say that I would like to open the Excel
file as a read/write database just like via the ODBC set up?No idea - you'll probably get a better response in an ODBC/OLEDB group,
or one for your programming language/environment - VB, C#, ASP etc. But
there is plenty of information available about connecting to Excel and
working with the data:

http://www.carlprothman.net/Default...roviderForExcel
http://support.microsoft.com/defaul...kb;en-us;278973

Simon|||what driver do you use for DSN?
A good check would be to open the DSN file with notepad and check that.

DM Unseen