title: SQL Server 2008 R2: Import table from text file when column names have a / in them
body: <p>How do you import a table into a database from a text file when that table has /'s in the column names?</p>
  
  <p>I have a SQL Server 2008 R2 table with columns that have /'s in their name.  (SAP Database)
  For example:  /BIC/FIC_SD001 has a column named /BIC/O_CST_00</p>
  
  <p>I have done an export (using the Import/Export Wizard) of this table to a text file and the slashes are there.</p>
  
  <p>When I import the table into a different database (using the wizard) all the /'s from the column are removed and replaced with spaces.
  The above column now looks like this:  BIC 0_CST_00</p>
  
  <p>Thank you in advance for your help!</p>