Visual Studio 2015 - connecting to Excel and CSV

  • Thread starter Thread starter Joseph_at_MaRS
  • Start date Start date
J

Joseph_at_MaRS

Guest
I've just started Visual Studio 2015 Professional with Data Tools enabled on Windows Server 2012. Trying to connect to either an Excel file or csv has not worked. I follow the steps:

  1. From VS, I click on "Tools"
  2. Click on "Connect to Database"
  3. Click on "Microsoft OBDC Data Source" (note there are no other "OBDC" choices from the list
  4. Click on "Use a connection string" and then "Build"
  5. Navigate to a folder that has oth a .xlsx file and a .csv file. Neither appear as visible. I can provide a screen capture.

So at this point I'm thinking I don't have the right driver. I navigate toand install the driver, but no change to Visual Studio (restarted VS but not the server).


All online help points to either SQL Server 2016 (I have 2012 and am upgrading, soon) or VS 2013 and use "Business Intelligence Tools" which doesn't seem available for VS 2015. What I want to do is really, really simple and you would think that Excel and VS, both being Microsoft products would play nicely together, but there seems to be a bunch of additional, non-intuitive steps that is turning into an exercise in frustration. If anyone can point to some steps that actually work for VS 2015 I would be forever grateful. Thanks in advance.

Continue reading...
 
Back
Top