Importing csv files must have a csv extension?

[James]

Hi,

I'm importing some csv files with this code

/// start of code snippet
int iPos = strFileName.Las tIndexOf(@"\");

string strPath = strFileName.Sub string(0,iPos);
string strSelect = "Select * from [" + strFileName.Sub string(iPos+1) + "]";

string strConnection;
strConnection = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=";

strConnection += strPath;
strConnection += ";Extended Properties='tex t;HDR=No;FMT=De limited'";

System.Data.Ole Db.OleDbConnect ion CSVConnection = new
System.Data.Ole Db.OleDbConnect ion(strConnecti on);
CSVConnection.O pen();

System.Data.Ole Db.OleDbDataAda pter CSVAdapter = new
System.Data.Ole Db.OleDbDataAda pter(strSelect, CSVConnection);

DataSet CSVDataset = new DataSet("CSVFil e");

CSVAdapter.Fill (CSVDataset, "CSVFile");

CSVConnection.C lose();

DataTable CSVDatatable;
CSVDatatable = CSVDataset.Tabl es["CSVFile"];

/// end of code snippet

I have found that only files with a .csv extension can be opened otherwise I
get an exception that read 'Cannot Update, Database or Object is read-only'.
Is that normal and is there a way around it?

Also, since I'm using the Microsoft.Jet.O LEDB.4.0 provider will the users
machine need to have Access or Office installed in order for this to work?

Finally, should I be using another provider, just wondering since I took
most of it from a sample code.

Thank you for your time.

[Nicholas Paldino [.NET/C# MVP]]

James,

I don't know of any limitation that prevents you from using a text file
with an extension other than csv, but I can't say without a doubt that this
isn't a limitation.

You might want to try the text driver with the classes in
System.Data.Odb c, it might provide a better experience for you.

I believe the connection string would be something like this:
Driver={Microso ft Text Driver (*.txt;
*.csv)};Dbq=c:\ somepath\;Exten sions=asc,csv,t ab,txt;Persist Security
Info=False;

Note you can set the extensions in the connection string.

You won't be required to have Access installed to run Jet, you just have
to have the support files for the Jet provider, should you choose to use it.
It's just that Access typically installs this.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"James" <[e-mail]> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hi,

I'm importing some csv files with this code

/// start of code snippet
int iPos = strFileName.Las tIndexOf(@"\");

string strPath = strFileName.Sub string(0,iPos);
string strSelect = "Select * from [" + strFileName.Sub string(iPos+1) +
"]";

string strConnection;
strConnection = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=";

strConnection += strPath;
strConnection += ";Extended Properties='tex t;HDR=No;FMT=De limited'";

System.Data.Ole Db.OleDbConnect ion CSVConnection = new
System.Data.Ole Db.OleDbConnect ion(strConnecti on);
CSVConnection.O pen();

System.Data.Ole Db.OleDbDataAda pter CSVAdapter = new
System.Data.Ole Db.OleDbDataAda pter(strSelect, CSVConnection);

DataSet CSVDataset = new DataSet("CSVFil e");

CSVAdapter.Fill (CSVDataset, "CSVFile");

CSVConnection.C lose();

DataTable CSVDatatable;
CSVDatatable = CSVDataset.Tabl es["CSVFile"];

/// end of code snippet

I have found that only files with a .csv extension can be opened otherwise
I
get an exception that read 'Cannot Update, Database or Object is
read-only'.
Is that normal and is there a way around it?

Also, since I'm using the Microsoft.Jet.O LEDB.4.0 provider will the users
machine need to have Access or Office installed in order for this to work?

Finally, should I be using another provider, just wondering since I took
most of it from a sample code.

Thank you for your time.

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Take a look at the opennetcf.org csv's provider. It does works great and you
have the source code too !

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"James" <[e-mail]> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hi,

I'm importing some csv files with this code

/// start of code snippet
int iPos = strFileName.Las tIndexOf(@"\");

string strPath = strFileName.Sub string(0,iPos);
string strSelect = "Select * from [" + strFileName.Sub string(iPos+1) + "]";
string strConnection;
strConnection = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=";

strConnection += strPath;
strConnection += ";Extended Properties='tex t;HDR=No;FMT=De limited'";

System.Data.Ole Db.OleDbConnect ion CSVConnection = new
System.Data.Ole Db.OleDbConnect ion(strConnecti on);
CSVConnection.O pen();

System.Data.Ole Db.OleDbDataAda pter CSVAdapter = new
System.Data.Ole Db.OleDbDataAda pter(strSelect, CSVConnection);

DataSet CSVDataset = new DataSet("CSVFil e");

CSVAdapter.Fill (CSVDataset, "CSVFile");

CSVConnection.C lose();

DataTable CSVDatatable;
CSVDatatable = CSVDataset.Tabl es["CSVFile"];

/// end of code snippet

I have found that only files with a .csv extension can be opened otherwise I get an exception that read 'Cannot Update, Database or Object is read-only'. Is that normal and is there a way around it?

Also, since I'm using the Microsoft.Jet.O LEDB.4.0 provider will the users
machine need to have Access or Office installed in order for this to work?

Finally, should I be using another provider, just wondering since I took
most of it from a sample code.

Thank you for your time.

[James]

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

James,

I don't know of any limitation that prevents you from using a text file with an extension other than csv, but I can't say without a doubt that this isn't a limitation.

You might want to try the text driver with the classes in
System.Data.Odb c, it might provide a better experience for you.

I believe the connection string would be something like this:
Driver={Microso ft Text Driver (*.txt;
*.csv)};Dbq=c:\ somepath\;Exten sions=asc,csv,t ab,txt;Persist Security
Info=False;

Note you can set the extensions in the connection string.

You won't be required to have Access installed to run Jet, you just have to have the support files for the Jet provider, should you choose to use it. It's just that Access typically installs this.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

Thanks for your help.

I tried it but started getting the 'data source name not found' error which
was like a scary flashback to my DAO days. I tried a few variations but I
think I'll stick to the Jet for a while.