Home Forums SQL Server 2005 Development Bulk insert from file having varying number of columns RE: Bulk insert from file having varying number of columns

  • November 12, 2013 at 10:05 am

    #1665794

    Jeff Moden (11/12/2013)

    Lowell (11/12/2013)

    here's my linked server example for a 64 bit folder full of text files that may help:

    Very cool. I've not actually used the ACE drivers, yet (had other problems that would take too long to explain) but now I have a great example for how to use them to solve the ragged-right problem.

    yeah i went to some effort to update all my 32 bit examples that i collected over the years, and update them to work in the 64 bit environment too. there wasn't enough examples out there of working 64 bit linked servers.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!