Import .CSV to SQL Table
BULK INSERT New_Table FROM 'c:\csvfile.txt' --or a .csv file WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO
Yes, so gracefully simple…
Just create the table beforehand 
My Shared Feed
- Google Will Discontinue Google Buzz and Code Search October 14, 2011
- Cardboard Warfare 2 October 12, 2011
- Alien Dalvik 2.0 Brings Android Apps to the iPad October 6, 2011
- Paintball in Potch September 23, 2011
- Paintball in Potch September 23, 2011
- Dog Food Tease September 19, 2011
- SABC 2's Riaan Cruywagen Remix...September 2011 September 15, 2011
- Finally, YouTube Will Let You Edit Your Videos Online [Video] September 14, 2011
- Grammar Nazis September 14, 2011
- Stormtroopers' 9/11 September 14, 2011
- Subscribed to CALLOFDUTY September 13, 2011
- G.O.S.P.E.L. - Propaganda (Official Video) August 20, 2011
- DC SHOES: KEN BLOCK'S GYMKHANA FOUR; THE HOLLYWOOD MEGAMERCIAL August 18, 2011
- Battlefield 3: Paris Multiplayer Gameplay August 17, 2011
- Battlefield 3: Caspian Border Gameplay August 17, 2011
- Google+ Games August 12, 2011
- TeamSpeak for Android Beta is Now Available August 10, 2011
- How to completely butter your movie theater popcorn with a straw. August 8, 2011
- Gigabyte G1 Assassin motherboard is a last-gen gamer's dream come true July 25, 2011
- Kung Pow - Badong July 22, 2011
OMW i am so going to kill you for this. Been searching for a way to do something like this and just kept on hitting dead ends.
Gratis
Hello Readers,
Please go to following link :
http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/
It has explained the same concept in detail.
Regards,
Pinal Dave ( http://www.SQLAuthority.com )
[...] Import .CSV to SQL Table [...]
20,000 hits « Welcome to the Fallout said this on April 15, 2009 at 11:43 pm |
I’m using the same insert code but FIELDTERMINATOR = ‘”,”‘ however when their is a Null in a column it throws an error. Is there anyway round this?
Thank you