SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member BubbaBelly's Avatar
    Join Date
    Sep 2002
    Location
    El Paso, TX
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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
    echo "bubbabelly at your service...";
    http://bubbabelly.blogspot.com

  2. #2
    SitePoint Wizard Chris82's Avatar
    Join Date
    Mar 2002
    Location
    Osnabrück
    Posts
    1,003
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi.

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


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •