Importing data from txt files

[TomBarrand]

I would like to import data from txt files. There will be several txt files in a specified location. I have looked at using BCP is this correct? and is it possible to import data from more than one txt file?

Thanks,

Tom

 

[foxdev]

BCP would probably be the fastest in execution, but for ease of development and modification you might consider using DTS. Start off by using the Import Wizard to build a basic import DTS job, then open and modify it as needed. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[tlbroadbent]

You can use BCP, Bulk Insert or DTS (Data Transformation Services) to import from text files. The documentation in SQL BOL explains clearly how to use each method.

You can create a batch file to run multiple BCP's to import multiple files. You can create a T-SQL script or stored procedure to execute multiple Bulk Inserts. And you can create Multiple DTS packages or one DTS package with multiple steps. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.