title: Excel table names contain a '$' when pulled from a schema in VB.net
body: <p>I have a list box that I'm trying to populate in an application to contain Excel tab names or Access tables. It's created by a simple schema grab:</p>
  
  <pre><code>dtSheet = OpenCon.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
  </code></pre>
  
  <p>It then gets put into a simple list (of String):</p>
  
  <pre><code>For Each Row In dtSheet.Rows
      ListOfSheets.Add(Row("TABLE_NAME").ToString())
  Next
  </code></pre>
  
  <p>This works fine if I open up an Access database, the names of the tables are listed nicely. However, when I use it for Excel, I get symbols such as $ and quotes "'". I'd like to trim this off to just have the tab names but so far I haven't been able to find anything to help my issue specifically.</p>
  
  <p>My suspicion is that the answer is in the {Nothing...."TABLE"} object. I'm a little light on how filters like this work and I was having issues wrapping my head around it after reading the .NET documentation.</p>
  
  <p>Another idea would be to do some post string alteration trimming but I'd like to see if there was an easier way to get the simple string name that I want from the start.</p>
  
  <p>Any help would be appreciated.</p>