Results 1 to 5 of 5

Thread: can sqlldr.exe be used to load a csv file into ms sql server

  1. 10-17-2008, 01:58 PM #1
    ravibput
    ravibput is offline Registered User
    Join Date
    Oct 2008
    Posts
    9

    can sqlldr.exe be used to load a csv file into ms sql server

    sqlldr.exe is compatible with oracle but is it compatible with MS Sql server?
    Reply With Quote Reply With Quote
  2. 10-17-2008, 02:42 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Not sure of that. But sql comes with data loading tools like bcp, bulk insert, data import wizard and dts/ssis.
    Reply With Quote Reply With Quote
  3. 10-18-2008, 03:15 AM #3
    ravibput
    ravibput is offline Registered User
    Join Date
    Oct 2008
    Posts
    9
    thanx FYI i will be trying to solve it with the tools.......... provided.
    Reply With Quote Reply With Quote
  4. 10-19-2008, 06:12 PM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    No SQLLDR only works with Oracle.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  5. 10-22-2008, 02:00 PM #5
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    open SQL Server management studio and run BULK INSERT command. or use BCP.exe to import the file.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules