BULK INSERT ON CSV FILE. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

BULK INSERT ON CSV FILE.

Author

Topic

mcupryk
Yak Posting Veteran

91 Posts

Posted - 2011-02-22 : 22:16:22

name of file name: C:\Users\omegalove\Documents\IP.csv

table definition:
CREATE TABLE [dbo].[IPCITYLATLONGISPDOMAIN] (
[ipFROM] [float] NOT NULL ,
[ipTO] [float] NOT NULL ,
[countrySHORT] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[countryLONG] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ipREGION] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ipCITY] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ipLATITUDE] [float] ,
[ipLONGITUDE] [float] ,
[ipISP] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ipDOMAIN] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

FIRST THREE LINES
<CODE>
"0","33996343","-","-","-","-","0","0","-","-"
"33996344","33996351","UK","UNITED KINGDOM","-","-","54.15","-4.473","BT NORTH BLOCK CAMBRIDGE","BT.COM"
"33996352","50331647","-","-","-","-","0","0","-","-"
</CODE>

Any help would be awesome.

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2011-02-22 : 23:36:29

Have a look at:
http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-02-24 : 04:05:21

Also refer
http://beyondrelational.com/blogs/madhivanan/archive/2010/03/17/bulk-insert-to-table-with-specific-columns.aspx

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources