title: OledDbDataAdapter "Syntax error in FROM clause" exception
body: <p>I'm using OleDB to import data into grid from text file with extension ".K$$".</p>
  
  <p>Here's some example code:</p>
  
  <pre><code>FileInfo file = new FileInfo(filename);
  string connectionString = "";
  OleDbDataAdapter adapter;
  OleDbConnection con;
  
  connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + file.DirectoryName + ";Extended Properties=\"Text;Format=TabDelimited;\"";
  
  con = new OleDbConnection(connectionString);
  con.Open();
  adapter = new OleDbDataAdapter(String.Format("SELECT * FROM {0} ", file.Name), con);
  
  adapter.Fill(MyDataTable);
  </code></pre>
  
  <p>when executing the Fill method it throws the exception. What's wrong with the FROM clause? Thanks</p>
  
  <hr>
  
  <p>EDIT:</p>
  
  <p>Ok, after some tests I found out that the problem is with the "$" symbols. Maybe it's some reserved symbol ? 
  Also, if I rename the extension to ".txt" the file got loaded into the grid but it only have 1 column , which means it can't see that there're tabs in the rows. </p>
  
  <p>Another issue is that when I change the file extension to something different than ".txt" (for ex. ".tx") the Fill method throws exception "Cannot update. Database or object is read-only".</p>