>
>What is the app you must import into? I'm asking because I remember I had to do something like that once... but I don't remember why! :) After I wrote my own small proc to do this, I found a format accepted by EXPORT that gave me exactly what I wanted. But I don't remember why I had this need, neither if the format was exactly what you need.

The app is 3rd party program called Transformer Analyst, written in Visual
Basic using an Access database. I know I could probably very easily use Access
to import the data into the table. But I am writing this small app for someone
else to use.

>>the proper fields. Right now my SQL statement is creating a table,
>>but I think it will be more efficient if I change it and go into a cursor
>>and work with that, as I don't need to keep what the SQL creates. Any suggestions
>>will be appreciated.
>
>Obviously, if it's a temporary table, it should be a cursor! :) Other suggestions? Look at the EXPORT command. Maybe it knows how to create a file in the format you want.
>
>Vlad

Thanks for the suggestions on the Cursor and Export commands. I will check'em out.

Elgin
Epic Solutions.