Pulling a flat file into format for PH (Jeff Hoffman)

[Jeff Hoffman]

Hi Karen

bcp is a dbms utility for bulk copying data into/out of an rdb.

BTW: if you create a table and are not sure of the data use large 
varchar columns, that way data will load and you can use qtp to 
reformat it when you update the actual database.

Regards
Jeff



At 06:35 AM 31/08/2011, you wrote:
>Thanks Jeff -
>
>Table approach is OK but harder for us with Sarbanes Oxley 
>reqs.  But what does bcp mean?
>
>Karen
>
> > Today's Topics:
> >
> > 1. Re:Pulling a flat file into format for PH (Jeff Hoffman)
> >
>
> >
> > Hi Karen
> >
> > Replace commas with TAB
> > build a table in an RDB
> > bcp file into table
> > use table to update your data using qtp
> > drop table or truncate table if you expect to do it again.
> >
> > Regards
> >
> > Jeff Hoffman
> >
> > At 08:21 AM 30/08/2011, you wrote:
> >
> > >Hi All,
> > >
> > >I used to know how to do this but too many years since last time.
> > >Users want to send me a delimited file to use for updating tables. I
> > >seem to recall that I made a subfile with a defined line (just one
> > >big one) and then copied the csv on top of the .sf. After that I
> > >could parse out the fields using index to locate the
> > >delimiters. I'm not getting a fixed length line so this is not working.
> > >
> > >Ideas? Thanks in advance!
> > >
> > >Karen Barrett
> > >Elk Point, SD
> > >360 608-6243
>
> > This list is closed, thus to post to the list you must be a subscriber.
> > Add 'site:lists.sowder.com powerh-l' to your search terms to 
> search the list archive at Google.
> >
> > End of powerh-l Digest, Vol 75, Issue 4
> > ***************************************
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: 'unsubscribe <password>' in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search 
>the list archive at Google.