Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connection to Excel from .Net using Oledb
I have a custom CRM app that opens up an uploaded excel file and then uses
the crm objects to insert new contacts.. but here is my problem.. im uploading it to our test server and unless the user uploading the file is an system admin on the box they are unable to open the excel file.. the connection im using is.. String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + FullPath + ";Extended Properties=Excel 8.0;"; //UID=CRMAdmin;PWD=CRM23Admin; after testing the code i have found that it fails on connect.. even when i use a user name \ password for a user that is an system admin on that box (one that i have setup //UID=CRMAdmin;PWD=CRM23Admin;) the error that I now recieve is "Could not find installable ISAM".. Excel is not installed on this server.. ideas?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define OLEDB connection string | Excel Programming | |||
Using OleDB to get data from Excel | Excel Discussion (Misc queries) | |||
OLEDB Help Excel 2002 | Excel Programming | |||
EXCEL AND OLEDB | Excel Programming | |||
Excel schema using Jet OLEDB Provider? | Excel Programming |