title: Import raw data from excel into another excel
body: <p>I'm using the following Code to import a raw data extract (mysql; output format *.xlsx) from an excel sheet (source) into a sheet (target). </p>
  
  <p><a href="https://stackoverflow.com/questions/7876178/importing-excel-spreadsheet-data-into-another-excel-spreadsheet-containing-vba">Importing Excel spreadsheet data into another Excel spreadsheet containing VBA</a></p>
  
  <p>The target sheet is a excel-template contains some macros e.g. to allow users to easily sort data.</p>
  
  <p>All is working very well, except that some data are malformed after import. Its really strange but due to any reason target is not an exact copy of the source sheet. Issues I've for example with date format and decimals. </p>
  
  <p>I've tried several things to tweak the code but failed.
  I believe that the way how the import in target sheet is handled by code is the reason why it doesnt work.</p>
  
  <p>Now my question is if there exits any other way to import data from excel to excel.
  Also I'm looking for a solution how I could solve the problem that excel formats all values automatically as text?</p>
  
  <p>Any help would be highly appreciated.</p>
  
  <p>Kind regards </p>