Post reply

Column limitations when using OpenRowSet to import a txt file into a sql server table

  • February 20, 2009 at 1:26 pm

    #197432

    Hi All:

    I have a situation where I need to read a text file and import it into a table.

    I know that MAX number of columns in a base table is 1024. Does this apply when using OpenRowSet too??? Or is it only 256 when using Open Row Set

    Thanks

  • February 20, 2009 at 8:08 pm

    #948082

    I tried to research this issue but couldn't find anything definite. However, if you use OpenRowset with a BCP format file, you are usually going to create the the format file from a query that would export a table to file. That suggests that the same limitation on number of columns would apply.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply