Sometimes, not always, when loading an MSSQL table from Excel a new table suffixed with a $ is created by MSSQL. Why?



  • We are loading MSSQL tables via Microsoft Management Studio Import. Sometimes, not always, a new identical table is created in the load process with a $ at the end of the name. Why does this happen? Is this related to the IDs?



  • From https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5a5395d9-a075-46e7-ac0e-62c3bbd23fbb/datatable-names-with-symbols?forum=sqltools :

    Excel object names that are appended with a dollar sign ($) represent worksheets (for example, Sheet1$), and that plain object names without the dollar sign represent Excel named ranges.

    So the tables you are seeing with the dollar sign came from Excel worksheets.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2