I would like to know the best way to BULK copy a specific portion of a table (specified by query) into another table in another Database. The tables are defined exactly the same. Currently I have been unsuccessful in going to file first because one of the columns is of type text and the import always fails because the text data column invariable always contains the field terminator. Is there a way to encode the text column? What is the best way to successfully copy the tables? Please provide full syntax if possible.