EXCEL SQL Problem

[brucelim80]

hi can anyone help me with this problem?

I have a excel raw datafile call holdmail register.xls which is
protected with password when open.

When i use another excel to query using ADODB connection as show below



Dim cn As ADODB.Connection
Set cn = New ADODB.Connection


With cn
..Provider = "Microsoft.Jet.OLEDB.4.0"
..ConnectionString = "Data Source=C:\Documents and
Settings\43230121\My Documents\Working folder\Holdmail\Hold mail
register.xls ;" & _
"Extended Properties=Excel 8.0; User ID=HSBC;
password=holdmail"
..Open
End With


It show me an error as show below
Cannot Start Application. The Workgroup information file is missing or
opened exclusively by another user



The problem is that the file was not open.
Can anyone help me ?

Thank you,

 

[raypayette]

I know that older versions of Excel had some "database" capabilities
that have not been continued. Perhaps this is the cause of your
problem.

 

[tony h]

what happens

A - if you try to open it as a spreadsheet - ie do you get the same
error?
B - if you try to open it as a spreadsheet in code?

might help to diagnose the problem

 

[brucelim80]

hi

i have encountered the same problem when i create a new workshee
protected with password. The password is used to open the excel file.

When i wrote another excel to query using ADODB Connection. It wil
give me the same error.

When i open the raw data, it working fine after entering the passwor

 

[tony h]

Theses articles may help:

http://support.microsoft.com/?scid=kb;en-us;300699

http://www.programmingtalk.com/showthread.php?t=7763

http://experts.about.com/q/Visual-Basic-1048/VB-MS-Access-connection-1.htm

sorry haven't got time at the moment to look further