title: Copy float data to varchar from table to another after excel import
body: <p>Hello I have imported data from Excel via <code>Import and Export wizard</code> to my SQL Database 2008. When importing some of the columns were detected as <code>nvarchar</code> and some of them as <code>float</code>. I imported all data successfully.</p>
  
  <p>Now I want to copy those data to another table thourgh this query:</p>
  
  <pre><code>INSERT INTO dbo.klient
    (name, surname,rodcis,nopass,street,zip,city,appendix,tel,fax,titul,akce,rocnik)
  SELECT [nameorig], [surnameorig],[rodcisorig],[nopassorig],[adresa],[zip],[city],[apporig],[telhomeorig],[telworkorig],titul,'000000-00',2014
    FROM dbo.UCAST3$
  </code></pre>
  
  <p>E.g. column <code>rodcisorig</code> contain values like: </p>
  
  <pre><code>7102112688
  
  500722142
  
  515524172
  </code></pre>
  
  <p>Those columns, that were detected as <code>float</code> when I try to copy them to <code>varchar</code> column I get from mentioned cells values like this:</p>
  
  <pre><code>5.25317e+009
  
  6.15131e+009
  </code></pre>
  
  <p>Would somebody help me solve this out please?</p>