I'm creating a program for work and need to import a flatfile(normal text file) into Oracle. I'm using VB. The flatfile is delimited and the first row is the field heading, the delimiter is comma and the text qualifier is ".

When the mainframe kicks out the nightly export or "flatfile", I need my app to pick it up and import it into an Oracle table. I can get my app to read the flatfile but how do I create a table based on the fields in the flatfile? Can I create an array for this? How would I do it?

Thanks,

opiate