LOAD DATA INFILE...MSSQL??!?! help

[BubbaBelly]

Hello,

I am using PHP and MSSQL for my website, and I want to upload a CSV file as a table. However, MSSQL seems to not support the LOAD DATA INFILE command. I know this works in MySQL. So I was wondering, what is the MSSQL alternative/equivalent to the MySQL LOAD DATA INFILE??? Your help is much appreciated...thanks in advance...

Bubba

[Chris82]

Hi.

The MSSQL equivalent is "BULK INSERT". http://msdn.microsoft.com/library/de...ba-bz_4fec.asp