sql-import-wizard

Sql Import wizard imports 1022868890 as 1.02287e+009

I'm trying to import some data from Excel to SQL Server, I have a TEXT column with some numbers in it, some of the numbers go over just fine, and some turn into scientific form. Column in Excel is "text" type, column in the target sql table is varchar(255) Here are some examples: Excel [text] -> SQL Server [varchar(255)] 03138522...

Can I do a foreign key lookup while importing data into SQL Server 2005?

Background I have a spreadsheet of data that I'm importing into SQL Server 2005. I'm using the Import Wizard in Management Studio to do this. Problem I'm importing the data into Table A. Table A has a foreign key reference to Table B. My spreadsheet contains a value in Table B and I need the key for that value so I can put it into Ta...