Automate Text importer

[KeithH]

Has anyone found a way to automate or record a macro for importing text using PL/SQL Developer's Text Importer?

 

[JBrien]

What are the chances I was going to ask this same question on the same day?

I'd be interested in any information about this too.

Meanwhile, I'm looking into the SQL Loader utility. It's the same concept, you define a control file, then load files to tables using that definition.

My other option would be to concatenate all the files I have with the same layout, and import them as one large file, system limits permitting.

 

[KeithH]

SQL Loader would be an option if loading the data is something that is repeative on a daily or hourly basis. You will have to run it from a command prompt or use a GUI. But if you are going to use a GUI, use PL/SQL Developer. It is easier. I am looking to leverage PL/SQL Developer, since that is what are developers know. Recording a macro would be the ideal solution, but I can not find a way to open the data file and the associate definition file without using the mouse. The macro tool only captures keyboard strokes.