PC Review


Reply
Thread Tools Rate Thread

Connecting to Excel Spreadsheet with a password, need help in connectionstring.

 
 
Cade Carvell
Guest
Posts: n/a
 
      31st Jul 2003
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 OLEDBatabase Password=XYZDE>;"

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting Excel spreadsheet to BCM =?Utf-8?B?c2hhd25lMTk2MA==?= Microsoft Outlook BCM 6 14th Jul 2009 03:16 AM
Re: Connecting an excel spreadsheet to a generic letter in Word Trevor Shuttleworth Microsoft Excel Misc 0 6th Dec 2006 10:20 PM
Re: Connecting an excel spreadsheet to a generic letter in Word Gord Dibben Microsoft Excel Misc 0 6th Dec 2006 10:14 PM
Add password to connectionstring =?Utf-8?B?Sm9iIExvdA==?= Microsoft Dot NET 1 20th Jan 2006 05:05 AM
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? oil_driller Microsoft Excel Misc 1 8th Feb 2005 09:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:13 PM.