Jump to content
Xtreme .Net Talk

How to create a connection to Excel

hog
 Share

Recommended Posts

hog Newbie

hog

Posted
Posted

If I use this connection string in code:

 

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\returns.XLS;Extended Properties=Excel 8.0;

 

I can connect to the .xls file.

 

How do I create this connection using server explorer? Each time I try using this I get all sorts of error:(

My website

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...