DosTips.com

Thanks for your post!!! I'll try that too and see which one works best for me.

I was able to create a bcp to create a format file and map the fields of the data file to the columns of the table.

I have two comma delimited files that I need to import into two different tables. The first file has rows with columns like this: 6,11253,GIFT SHOP,0.05,05/08/2012, but the columns need to be rearranged like this: 6,11253,05/08/2012/GIFT SHOP,0.05, The second file has rows with columns like this: 1,...