none
Data Sources RRS feed

  • Question

  • I am new to Visual Studio and wondering how I would add a new data source as a shared drive? I am trying to connect to my teams shared drive so that I can pull in .txt files and load them into my SQL Server. I can connect to my SQL Server just fine but am having issues finding the right data source in the wizard to use to map to the network drive and grab those files. I have looked through search and online for help and finally decided to contact a VS forum.
    • Moved by 宝宝徐 Thursday, September 21, 2017 6:36 AM
    Monday, September 11, 2017 4:03 PM

All replies

  • Hi Tina,

    May I ask what kind of project you've created in Visual Studio? 

    This forum is for Visual Studio IDE issues, SSDT forum might be a better place where you could more professional answer.

    Thanks for your understanding. 

     

    Best regards,

    Fletcher


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    • Edited by Fletch Zhou Tuesday, September 12, 2017 9:23 AM
    Tuesday, September 12, 2017 9:23 AM
  • If I understand what you are asking, you can use the Microsoft Access OLEDB Provider to create the Data Connection. Just make sure to set the Extended Properties. The Database file name will the path to where the text files are located:


    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Proposed as answer by Fletch Zhou Monday, September 18, 2017 8:54 AM
    Tuesday, September 12, 2017 5:18 PM