insert data from text files into an existing sql 2005 database

By jcroucher ·
Hi all,
Have in excess of 1000 txt files containing data that needs to be inserted into an existing sql 2005 database.

These txt files may have some null fields. All fields in the txt files are in the same order as the fields in the sql database.

Each record in the sql database has an additional numeric field at the end of the record that does not exist in the txt file.

Have tried several methods to insert the data including BCP and bulk insert statements.

Would like a script that can be generated quickly and easily without the need to do mapping between each field in the txt files and the sql.

Any help would be greatly appreciated.
thanks in advance ... Jul

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums