Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Define OLEDB connection string John Excel Programming 3 February 21st 05 04:23 PM
Using OleDB to get data from Excel dvd00 Excel Discussion (Misc queries) 1 November 30th 04 04:32 PM
OLEDB Help Excel 2002 Brian Belger Excel Programming 1 September 28th 04 08:56 AM
EXCEL AND OLEDB Yama Excel Programming 4 February 25th 04 03:29 PM
Excel schema using Jet OLEDB Provider? mike Excel Programming 1 December 22nd 03 09:25 AM


All times are GMT +1. The time now is 01:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"