20
Reply

Error on delimited...

Janis Peksa

Janis Peksa

Jul 6 2011 1:39 AM
2.7k
Hello, have problem with delimited on one PC but on mine is everything good.
I have WinXP but my friend Vista.

Here is the code:

string AccessKonekcija2 = null; AccessKonekcija2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\exports_blaise2\\" + textBox22.Text + ".mdb";  System.Data.OleDb.OleDbConnection AccessExcelKonekcija = new System.Data.OleDb.OleDbConnection(AccessKonekcija2); System.Data.OleDb.OleDbCommand AccessExcelKomanda = new System.Data.OleDb.OleDbCommand(); AccessExcelKomanda.Connection = AccessExcelKonekcija;  AccessExcelKomanda.CommandText = "SELECT * INTO[Text;HDR=Yes;FMT=Delimited;DATABASE=C:\\exports_blaise2\\zips\\manipulai\\" + value3 + "\\" + textBox22.Text + "\\OUT].[" + value3 + "man.txt] FROM " + value3 + "man"; AccessExcelKonekcija.Open(); AccessExcelKomanda.ExecuteNonQuery(); AccessExcelKonekcija.Close();


And the error is:
http://uploadpic.org/storage/2011/fA...re4DT26l5O.png

Can someone tell me whats wrong ?
And how come that I can do that w/o an error.
But my friend not.

I already checked regional setting they are both equal.

Answers (20)