November 23, 2009 at 9:20 am
Sorry, the title of this post should read SQL 2005 not 2000...
I have an Excel speadsheet that has a column of IP addresses with the standard format of xxx.xxx.xx.xx. All other columns in the spreadsheet import fine except this column. After some researching on the web and testing I am unable to get this IP address column to import no matter what table type I use.
Can anyone suggest a way to import this data and retain the xxx.xxx.xx.xx format.
Thanks
November 23, 2009 at 10:24 am
What has worked for me is to change the excel column data type to text and then import to a varchar field.
Another option is to use MS Access as a go-between. Import the data into access and then into SQL Server.
The last option off the top of my head is to use SSIS to import the data.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 23, 2009 at 10:25 am
What tool are you using to do the import? I agree that it is a varchar(15). It is text as far as the database is concerned.
CEWII
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply