How can I read CSV files without Microsoft Access Runtime installed?

You can implement your own method to read and parse the CSV file. There's plenty of examples in various languages on the Internet. Also, generative AI chatbot can produce examples for you too.

👍🏼  I see....  That complicates things....

DDT.CSVDriver throws an exception when Microsoft Access Database Engine data access components are not installed. It's also listed as a pre-requisite for DDT on your (outdated) site here: 

https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/csv-storages.html

So, they are not going to move to the 64 bit supported version.  That stinks.  So yeah, creating a function / method to read it and call it from a script or a KWT would be the best way.   

>>  aqFile, aqTextFile, aqString <<   

https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqfile/methods.html

https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqtextfile/methods.html

https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqstring/methods.html

Once built a single function or method could read and parse the data for your existing looping structures.  It could be called through out your projects.  It would require a lot of re-factoring which stinks.

What is your environment now?  Are your project(s) are script built or KWTs?  It mostly matters for how comfortable you are with scripting.   

Hi Rachel53461,

A CSV file is just a text file as you likely know.  It can be read straight in as text and added to an object.  aqFile, aqTextFile, aqString  

You don't need the MS Access runtime.

Another option is the DDT.CSVDriver...

https://support.smartbear.com/testcomplete/docs/reference/program-objects/ddt/csvdriver.html

Maybe I am not fully understanding your situation. If not hit me up with more information.

Always happy to help!

... If you find my posts helpful drop me a Like👍 Be sure to mark the post as the Solution✅ when you get one to help others out and to credit the one who helped you. 😎

... Also, what is preventing you from installing the 64 bit version to keep your same code in place?

The environment is Windows Server 64bit, and we're running the latest version of TestComplete x64 on it. Company policy prohibits installation of products that are EoVS, so we are not able to re-install Microsoft Access Database Engine 2016 now that it's gone EoVS. We also do not have Microsoft Office installed, nor does Access 365 Runtime appear to work.

This is the script that was reading from a CSV file. It crashes with an exception on line 13 where it tries to use DDT.CSVDriver since the Microsoft Data Access components are not installed. 

/**@@Function
 * getCSVTable: Reads a CSV file and returns a 0 based 1 dimensional array
 * Param {String} file: 
 * @returns a 0 based 1 dimensional array
 */
function getCSVTable(file)
{
  var table = new Array();
  var dataSource ="cloudapp" ;
	try
  {
	 	var DataSS =DDT.CSVDriver(file);
    for (colIndex = 0;colIndex <DataSS.ColumnCount;colIndex++)
    {
      colName[colIndex] = DataSS.ColumnName(colIndex);
    }
    //DataSS.Next();
    var rowCount=0;

    //Define Header into multidimensional array
    while(!DataSS.EOF())
    {
      table[rowCount] = new Object();
      for (colCount=0;colCount<DataSS.ColumnCount;colCount++)
      {
        var tempStr = "table[" + rowCount + "]." + colName[colCount] + "=" + "'" + DataSS.Value(colCount) + "'";
        if (eval(tempStr)=="$ID")
        {
        EntityID = Project.Variables.EntityID;
        tempStr = aqString.Replace(tempStr,"$ID",EntityID,true);
        }
        else
         if (eval(tempStr).indexOf(".sql")!=-1)
         {
         tempStr = getSqlResult(eval(tempStr),dataSource);
         
         }
        table[colCount] =eval(tempStr);        
      } 
      DataSS.Next();
      rowCount++
    }
    DDT.CloseDriver(DataSS.Name);    
	}
	catch (exception)
  {
	 	Log.Error("getCSVData: " + exception.description);
	}
	return table;	
}