title: MS Access: SQL to insert tab separated value file into a table?
body: <p>I've managed to insert the contents of a comma separated txt file using the SQL command</p>
  
  <pre><code>string sql = "INSERT INTO [" + tableName + "] SELECT * FROM [text;database=" + filePath + "].[" + fileName + "]";
  </code></pre>
  
  <p>Is there a way to modify this command for tab separated values or more generally to allow a custom delimiter? Please note that the database is of type .mbd, not SQL Server. </p>