How to import a text file into SQL Server using the Import WIZARD.

Posted on 2009-04-21
Last Modified: 2012-05-06
How to import a text file into SQL Server using the Import WIZARD.  I have a text file and I want to load the file into a SQL table using the SQL Table Import Wizard.
Question by:Hojoformo
    LVL 22

    Expert Comment

    The Import Wizard is pretty self explanatory . . . thus the name "Wizard". ;-)
    What does you text file look like?  (I.e., is it a comma separated file, a fixed format file, or what?)
    What problems are you having?  (Have you tried and there are data errors?  Have you tried and there is some of the rows of text don't have enough columns?  Or What?)
    LVL 12

    Expert Comment

    Here is a SQL 2000 tutorial video....

    Best thing is to just go through the wizard frist and then trouble shoot the errors if any.

    LVL 46

    Accepted Solution

    Hi Hojoformo,

    Have a look at the following:
    Use the Flat file option

    Good Luck!


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now