Connecting to excel spreadsheet with a password. I can't seem to get
the program to run properly I get the following error:
" An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll
Additional information: Format of the initialization string does not
conform to specification starting at index 139.
Can anyone point out were I made my mistake besides position 139. Does
anyone have a Con string that shows the attaching to excel 2002 with a
readonly password? I have posted my code below.
Dim COnstring As String
COnstring = "Provider=Microsoft.jet.oledb.4.0; Data
source=\\Abtlasr01\data\PRGRMMRS\FTP documents\FTP Master List.xls;
Extended Properties=""Excel 10.0""" & ",Jet OLEDB

atabase Password=XYZDE>;"
Da = CreateDataAdapter(New OleDbConnection(COnstring), "Select
* from [MembersSheet$]")
Da.Fill(ds)
DataGrid1.DataSource = ds
DataGrid1.SetDataBinding(ds, ds.Tables(0).TableName)