>I am currently trying to append a text file which contains more than 300+ fields. What is the best solution to append a text file without losing any of the fields??
In addition to what Bret said, you can also dump the flat file into one table to begin with, mapping a number of the text fields into one table field. Then split the table fields up afterward into 2 or more tables using SQL. Often you'll want to create child tables anyway...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
