CSV RSS

• • Reply
  

  saurabh jain

  Member

  107 Points

  85 Posts

  CSV

  Sep 27, 2011 07:27 AM|LINK

  I am trying to connect with CSV file and getting error "Could not find installable ISAM" when i fill dataset with dataadapter code that i used to connect with csv is this

  string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Database=D:\\DATA;HDR=NO;Extended Properties =csv;fmt=,IMEX=1;";
  OleDbConnection OCon = new OleDbConnection(strCon);
  string strQuery = "SELECT * FROM 2392011_0.csv";
   OleDbDataAdapter ODa = new OleDbDataAdapter(strQuery, OCon);
  DataSet Dst = new DataSet();
  ODa.Fill(Dst);

• • Reply
  

  Veera Pallat...

  Participant

  769 Points

  201 Posts

  Re: CSV

  Sep 27, 2011 07:36 AM|LINK

  Hi Saurabh

  This may be issue with connection string , You need to use the extended properties in "" just like

  ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" App.Path & "\..\Upload" & ExcelFileName & ".xls" & ";Extended Properties=""Excel 8.0;HDR=NO;IMEX=1"""

  http://social.msdn.microsoft.com/Forums/en-SG/adodotnetdataproviders/thread/62ee4978-ca29-48d3-9367-6dd4ab639d2d

   

  Thanks & regards
  Veera Pallati
• • Reply
  

  saurabh jain

  Member

  107 Points

  85 Posts

  Re: CSV

  Sep 27, 2011 07:50 AM|LINK

  hi Veera,

                Thans for reply.

  I made the changes what u suggest but it still giving me same error "could not found installable IASM"

  New connection what i was used is

  string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Database=D:\\DND_DATA;HDR=NO;Extended Properties =\"csv;fmt=,IMEX=1;\"";