title: Solving syntax error, missing operator when transferring XML contents to access table
body: <p>Hey I'm transferring the contents of an XML file to access. Now everything works but when I try transferring the data from the "desc" section of each node to the "desc" column in the access table I get this error (transferring all the other aspects of the cards work.):<a href="https://i.stack.imgur.com/4eFTz.png" rel="nofollow noreferrer">https://i.stack.imgur.com/4eFTz.png</a></p>
  
  <p>My XML file looks like this <a href="https://i.stack.imgur.com/RelPe.png" rel="nofollow noreferrer">https://i.stack.imgur.com/RelPe.png</a></p>
  
  <p>Would you know any ways to fix the issue? Also I had to avoid parameters because I tried using them and it would only get the contents of the first node (wouldn't cycle), so that's why I'm avoiding it. Here's my code:</p>
  
  <pre><code>Dim conn As New OleDbConnection
          conn = New OleDbConnection
          dbprovider = "Provider=Microsoft.ACE.OLEDB.12.0;"
          Dim databasePath = "Data Source = FULL YUGIOH ACCESS DATABASE.accdb;"
          conn.ConnectionString = dbprovider &amp; databasePath
          Dim ds As New DataSet
          Dim command As OleDbCommand
          ds.ReadXml("C:\Users\1964\Documents\Visual Studio 2015\Projects\YGO Access Test v10\bin\Debug\MyData.xml")
          Dim xmlRoot As XElement = XDocument.Load("C:\Users\1964\Documents\Visual Studio 2015\Projects\YGO Access Test v10\bin\Debug\MyData.xml").Root
  
          Try
              conn.Open()
              command = New OleDbCommand()
  
              Dim cardname As String
              Dim cardtype As String
              Dim carddesc As String
              Dim cardrace As String
              Dim cardimage_url As String
              Dim cardatk As Integer
              Dim carddef As Integer
              Dim cardlevel As Integer
  
              For Each cards As XElement In xmlRoot.&lt;cards&gt;
                  cardname = cards.&lt;name&gt;.Value
                  cardtype = cards.&lt;type&gt;.Value
                  carddesc = cards.&lt;desc&gt;.Value
                  cardrace = cards.&lt;race&gt;.Value
                  cardimage_url = cards.&lt;image_url&gt;.Value
  
                  cardatk = cards.&lt;atk&gt;.Value
                  carddef = cards.&lt;def&gt;.Value
                  cardlevel = cards.&lt;level&gt;.Value
                  command.Connection = conn
                  command.CommandText = "insert into hello ([name], [type], [desc], [race], [image_url], [atk], [def], [level]) values('" &amp; cardname &amp; "','" &amp; cardtype &amp; "','" &amp; carddesc &amp; "','" &amp; cardrace &amp; "','" &amp; cardimage_url &amp; "','" &amp; cardatk &amp; "','" &amp; carddef &amp; "','" &amp; cardlevel &amp; "')"
                  command.ExecuteNonQuery()
              Next`
  
  </code></pre>