Excel OLE DB connection string

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Excel OLE DB connection string

Message

22/03/2007 17:03:21

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

COM/DCOM et OLE Automation

Titre:

Excel OLE DB connection string

Divers

Thread ID:

01207361

Message ID:

01207361

Vues:

Hi,

Cant seem to get the connection string right. Keep getting the 'No named arguments' OLE error message.

I'm using the following:

   cConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + GETFILE() 
		+ [;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";]

Any help is greatly appreciated.

Thanks,
Arriyel

Speak using soft and sweet words in case you have to eat them later.