<div>
I would be happy to troubleshoot for you. I have my own screen share software that will allow us to share your screen.
</div>


I would be happy to troubleshoot for you. I have my own screen share software that will allow us to share your screen.

<div>
Can you just offer some things to try?
</div>


<div>
Try &nbsp;to use an ODBC connection, point to the folder(not file) and then in the query write &quot;Select * From YourFileName.TXT
</div>


Try  to use an ODBC connection, point to the folder(not file) and then in the query write "Select * From YourFileName.TXT

<div>
<div class="content wysiwyg-content">
I am trying to create a new data source in SSRS to connect to a csv file. &nbsp;Below is my connection string and i am getting a &quot;Could not find installable ISAM&quot; error message. &nbsp;I am using &nbsp;OLE DB as the Data source type.<br />
<br />
Connection String<br />
Provider=Microsoft.ACE.OLE<wbr />DB.12.0;Da<wbr />ta Source=\\SERVER\FOLDER\SUB<wbr />FOLDER;Ext<wbr />ended Properties=”text;HDR=No;FM<wbr />T=Delimite<wbr />d”
</div>
</div>


I am trying to create a new data source in SSRS to connect to a csv file.  Below is my connection string and i am getting a "Could not find installable ISAM" error message.  I am using  OLE DB as the Data source type.

Connection String
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\SERVER\FOLDER\SUBFOLDER;Extended Properties=”text;HDR=No;FMT=Delimited”

SSRS New Data Source to connect to CSV files

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.