Create Inserts from CSV via WebFocus and VBS

1. Create a simple webfocus report by dragging tablename to
output painter
2. Set output to 'COMT'
3. Run report
4. Drag resultant .CSV unto .VBS
5. Execute resultant .SQL

In this example I'm simply backing up a table. However, you could use the same concept to create a WebFocus report from multiple input sources and then if you name your output with 'tablename', and use the correct 'columnname' values for headings -- use to feed another system...

No comments:

Favorite Tweets