Mark wrote:

> Thank you Michael for your prompt email. I will send all the things you requested when I get back to work on Monday and have access to the workstation. To answer your question, I was hoping to import the entire file in one transaction.

Why? What's wrong with committing after every 10000 records? Of course your import tool has to support this possibility.

> The file is large and I know that is why they brought me in for the project. They were unable to import the data into any usable format. I received the data in one large file and I was reluctant to break it up if I could avoid it.

If the file has fixed field length, you may also use it as an external table. Once attached to your database, you can copy the data to the destination table with a single INSERT ... SELECT ... statement.


Cheers,
Paul Vinkenoog