EXCEL SQL Problem

**brucelim80** · 07-17-2006, 06:21 AM

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** · 07-17-2006, 07:21 AM

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** · 07-17-2006, 07:34 AM

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** · 07-18-2006, 02:22 AM

hi

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

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

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