Is it possible to format Excel/CSV file into fmt/XML file via BCP

• Jeff Moden

  SSC Guru

  Points: 1004414

  More actions

  December 7, 2015 at 10:51 pm

  #1844547

  shelir (12/7/2015)

  ---

  I installed both Import and Export Data Wizard (64 bit) and Import and Export Data Wizard (32 bit). Since Access and Excel have only 32 bit version provider the 32 bit wizard worked for me

  Here is a link to learn more: https://msdn.microsoft.com/en-us/library/ms141209.aspx

  Thank you

  Actually, Access and Excel also have a 64 bit "ACE" driver. MS says it's not actually a replacement for the 32 bit "JET" drivers but that's only because they don't want to support it like they did the "JET" drivers. You can get the drivers at the following URL...

  https://www.microsoft.com/en-us/download/details.aspx?id=13255

  It also contains a fairly decent CSV capability.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)