Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default OleDBConnection.Open() blocks with 100% CPU

Hi!

I create a database connection to an Excel 2007 .xlsx file using the
following connection string:

string cs = "Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=" + filename +
";Extended Properties=\"Excel 12.0;HDR=YES\";";

After instantiating an OleDbConnection, I call connection.Open().

This all works fine for a simple Excel file with three sheets, two of them
empty. A more complex version with eight filled sheets (no calculation on
them!) makes the Connection.Open() command block using 100% CPU. When I
execute the code while the file is opened in Excel 2007, everything works
fine.

Any suggestions?

Thanks for your attention,
Alex


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
Numbering in blocks on 5 Jason Excel non guru Excel Discussion (Misc queries) 4 July 14th 09 08:25 AM
counting blocks of 1's Bryan De-Lara Excel Worksheet Functions 10 February 18th 08 07:11 AM
Problem opening Excel 2007 file from OleDbConnection Dave Jenkins Excel Programming 1 October 24th 06 11:01 PM
find and paste Blocks Taru[_15_] Excel Programming 4 June 20th 06 04:40 AM


All times are GMT +1. The time now is 01:02 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"