RE: How to create a table from a fixed length file?

>> Essentially looking for fastest way to get from file to table.

The fastest way I can think of - in your specific instance would be to use the header in the data file to create a table defaulting all the datatypes to varchar of sufficient width to handle the fixed width in the data file.

Of course... if you don't have a header in the data file, then you get to put in more work effort by naming the columns.  Lots of other assumptions are involved which if incorrect mean more work effort :)

Roger S.

________________________________
This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.