Advanced Search

Return to Snippet

Revision: 63566
at May 17, 2013 04:03 by dego89
Initial Code 
BULK INSERT [table name]
FROM 'file path and name (either .txt or .csv)'
WITH
(
	FIRSTROW = 2,
	FIELDTERMINATOR = ',',
	ROWTERMINATOR = '\n',
	KEEPNULLS
)
GO
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Bulk upload a CSV into Microsoft SQL Server

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Bulk insert/upload microsoft sql server (csv)

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, csv

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL