469,568 Members | 1,673 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

Enterprise Library and reading an Excel file

Enterprise Library January 2006
Visual Studio 2005
Lanugage: C#

I am attempting to use the Enterprise Library to read data from an
Excel spreadsheet file. I got the following connection string from

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended
Properties="Excel 8.0;HDR=Yes;IMEX=1"

But when I use this with the Enterprise Library, it generates an
exception that the Provider keyword is not valid. Here is the text of
the exception:

Keyword not supported: 'provider'.: at
System.Data.Common.DbConnectionOptions.ParseIntern al(Hashtable
parsetable, String connectionString, Boolean buildChain, Hashtable
synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(Strin g
connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.SqlClient.SqlConnectionString..ctor(St ring
System.Data.SqlClient.SqlConnectionFactory.CreateC onnectionOptions(String
connectionString, DbConnectionOptions previous)
System.Data.ProviderBase.DbConnectionFactory.GetCo nnectionPoolGroup(String
connectionString, DbConnectionPoolGroupOptions poolOptions,
DbConnectionOptions& userConnectionOptions)
at System.Data.SqlClient.SqlConnection.ConnectionStri ng_Set(String
at System.Data.SqlClient.SqlConnection.set_Connection String(String
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.CreateConnection()
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.OpenConnection()
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.ExecuteReader(DbCommand

Can anyone provide me with some guidance in using the Enterprise
Library to read an Excel file correctly? I can use it no problem with
SQL Server.

The Excel file in question has only 5 columns, all integer type. I
wish to read the data from this file and insert it into a sql table.
Import won't work as this will have to be done on a regular basis and
there is some simple calculations that need to be performed.

Any help is appreciated.



Oct 20 '06 #1
0 2529

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by mail2atulmehta | last post: by
5 posts views Thread by Scott M. Lyon | last post: by
reply views Thread by hhravn | last post: by
9 posts views Thread by dba123 | last post: by
2 posts views Thread by =?Utf-8?B?Vmlua2k=?= | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.