Home Forums SQL Server 2008 SQL Server Newbies Importing multiple .txt files into one table - no SSIS RE: Importing multiple .txt files into one table - no SSIS

  • August 28, 2012 at 9:12 am

    #1530878

    it's fairly easy; you would want to use BULK INSERT to bring the text files into a SQL table...but you have to know the layout of the data, and create teh destination table (whether it's a "staging" table or the real table) before you do anything else.

    you also need to know how the file is delimtied...comma delimited , tab delimited, or fixed width, or some custom delimiter.

    the example you pointed out is pretty good; can you be more specific about where you are having trouble?

    can you give more specifics about your text files, how they are delimited, etc?

    what table have you created for it so far?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!