Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Unanswered: import csv file to sql

    I have several csv files which I need to import them to MS sql and create tables for each of them.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Aug 2008
    Posts
    147
    Check
    Bulk Insert CSV into a SQL Server table - SQL Server DBA

    this is a more manual way of approaching the problem.
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  4. #4
    Join Date
    Jun 2011
    Posts
    2

    csv file to sql

    actually I have csv file,I do not need to create it.I just need to import it to sql.
    there are 52 csv files to be imported to 52 tables in SQL.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The Import Wizard would be my first choice. BCP is a "Heavy Duty" tool for doing big jobs (large numbers of rows), and you'd have to manually create the tables before you could import the data using BCP.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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