title: Importing numbers with leading zeros from excel into SQL Server Management Studio
body: <p>I am trying to import numbers (postcodes) into a SQL DB using the SQL Server Import and Export Wizard. The column is text in Excel however when I import the file, the postcode column gets mapped to a float type which is causing NULL results for any values with a leading zero.</p>