Hi,

I have an application that fetches data from a .csv file. Following is the connection string that i have used

 Dim connString As String = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source={0};Extended Properties=Text", Path.GetDirectoryName(fileName))

where fileName is the name of .csv file.

The exe works fine on my system or on any system that has Visual Studio .Net installed. On all other systems though I am able to install the exe but it fails to fetch data. This happens despite installing .Net framework 2.0 and MDAC on the user machine.

Could somebody help me with this.

Many thanks in advance.

The error message thrown on the client machine is "Syntax error in from clause".
But works fine on my Computer on any computer with VS.Net installed

Hi everyone I have found the solution. Thanx for viewing my query.