title: Inserting German date format in SQL using VBA
body: <p>I'm pretty frustrated here, been trying this for days...
  All I want is for <em>German users</em> to be able to enter dates that should be stored in SQL Server. The dates are in the following format "dd.mm.yyyy". I always get error messages like this one: Syntax error in date in query expression '#23.01.2004 00:07:00#'. - using Access for now.</p>
  
  <p>I've tried lots of methods (Thread.CultureInfo, CDate(), Formatting DateTimeStyles) but here is my latest:</p>
  
  <pre><code>Dim dTermin As DateTime
  dTermin = DateTime.Parse(txtTermin.Text)
  
  sSQL = "INSERT INTO Termin (Termin) VALUES ("
  sSQL = sSQL &amp; "#" &amp; dTermin &amp; "#)"
  </code></pre>
  
  <p>That also gives me an error. If I hardcode a date like "10-04-2004" then it works, however. It's an Access 2000 db and there are two fields: ID (Autonumber) and Termin (ShortDate). Using Jet OLEDB 4.0 Provider.</p>