Referencing Excel Sheets with JET Driver Sheets Are Duplicated with Underscores

Posted by MasterMax1313 on Stack Overflow See other posts from Stack Overflow or by MasterMax1313
Published on 2010-12-22T15:51:41Z Indexed on 2010/12/22 15:55 UTC
Read the original article Hit count: 246

Filed under:
|
|

I'm referencing an excel document with the JET database driver, which was working just fine until one day the application failed. Upon further investigation I noticed that the tabs were duplicated in some instances (all tabs actually) - i.e. Tab1$ and Tab1$_. I've researched this issue and found that it is caused by the user applying a filter. Now the filters have been removed, no special formatting, frozen panes, or print formats, but still I have these tabs duplicated. Normally I'd code around this, but since we're in a code freeze I need to come up with an Excel based solution. I want to get rid of those crazy underscored tab names / reverences. I could probably run a program to clean up the file if necessary, to send it back to the users, but I want to explore Excel options first. Thoughts? I have Excel 2010, and access to any other version as well.

© Stack Overflow or respective owner

Related posts about excel

Related posts about .net-3.5