Home Forums SQL Server 2014 Administration - SQL Server 2014 use excel to update backend SQL Table RE: use excel to update backend SQL Table

  • January 19, 2017 at 10:55 am

    #1923796

    Jeff Moden - Thursday, January 19, 2017 10:46 AM

    You don't need SSIS.  The ACE drivers work just fine.  I install them as a matter of rote on every system.

    IMO, the ACE drivers are a pile of horse**** and not fit for purpose.
    Not only that, what they return depends on how data was formatted. How many people have been tripped up by getting a '-' returned after a column has been formatted as 'Accounting'? (Rhetorical)
    How about a column that contains numeric data until row 1000, when there's an 'x' in there? Can you tell the ACE driver to treat that column as text? Good luck with that, unless you're into registry hacks.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.