Microsoft.Jet.OLEB.4.0 code identification 1

[Jimmy24]

Dear Sir or Madam,

I have an excel spreadsheet, every cell contains the below code under query. Would you please tell me what is the purpose of the code...

Regards,

james



Provider=Microsoft.Jet.OLEDB.4.0;
User ID=Admin;Data Source=H:Emp phone directory list.xls;Mode=Share Deny Write;
Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";
Jet OLEDB:Engine Type=34;Jet OLEDBatabase Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;
Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;
Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;
Jet OLEDB:SFP=False

 

[SkipVought]

Hi,

What you posted is a connection string for a query to

H:Emp phone directory list.xls

I don't understand when you say that, "...every cell contains the below code..."

Where do you see this in the cell?

Skip,
[sub]
[red][/red]
[/sub]