Search found 3 matches

by kfriedley
15 May 2012 17:00
Forum: DOS Batch Forum
Topic: Adding a column to a csv file and populating it
Replies: 21
Views: 15998

Re: Adding a column to a csv file and populating it

Thanks for your post!!! I'll try that too and see which one works best for me.
by kfriedley
15 May 2012 16:57
Forum: DOS Batch Forum
Topic: Adding a column to a csv file and populating it
Replies: 21
Views: 15998

Re: Adding a column to a csv file and populating it

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.
:)
by kfriedley
14 May 2012 13:29
Forum: DOS Batch Forum
Topic: Adding a column to a csv file and populating it
Replies: 21
Views: 15998

Re: Adding a column to a csv file and populating it

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,...