HOW TO CREATE LINKED SERVER FOR CSV

• vignesh.ms

  Hall of Fame

  Points: 3456

  More actions

  August 26, 2013 at 6:27 am

  #279089

  Hi Everybody

  Please help me to write a query for creating linkedserver to read csv files.

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  August 26, 2013 at 6:54 am

  #1644848

  Are you sure you want to use a linked server? Because a .csv file is, you know, a file. Not a server.

  Maybe you want OPENROWSET?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP