Error on delimited...

Janis Peksa

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.

20 Replies

Know the answer? Post it — somebody with the same question will find it here.

Janis Peksa15y ago
I rewrited code.
Schema like this: .mdb to datagridview to text file.
Sam Hobbs15y ago
Your code is a sample use of OLEDB.
Janis Peksa15y ago
Give me sample for OLEDB.
Sam Hobbs15y ago
An easier solution is to export the data using something else. There are a few articles in this web site that suggest alternatives; I wrote one of them. The alternatives are easier than using OLEDB.
Janis Peksa15y ago
schema.ini file is for importing not exporting.
I placed schema.ini file with needed information in it.
But C# rewrites it.
I'm going to put the data in dataGridView and than export to .txt.
I think it will work good.
Vulpes15y ago
The problem may be due to the registry settings for the text driver being different on the two machines.

You can override the registry settings by creating a Schema.ini file (see http://msdn.microsoft.com/en-us/library/ms709353(VS.85).aspx) and storing it in the same directory as the text file.

So, assuming that ; is the delimiter, I'd try adding the following schema.ini file to the Vista machine.

[whatever.txt] // insert actual name here
Format=Delimited(;)
Janis Peksa15y ago
I'm tried this ways:
SELECT * INTO[Text;HDR=Yes;FMT=Delimited(;)
SELECT * INTO[Text;HDR=Yes;FMT=Delimited(|)

And still is ";" delimited.

I tried to change in regional settings "List seperator" to something else and no use of that.
I tried on other computer on who doesn't work delimited change to English (US) regional settings.
No changes for that and error appears.
Sam Hobbs15y ago
I don't understand what "can't" means. What can't you change? What happens when you try?
Janis Peksa15y ago
The first problem is that I can't change from ";" to anything else.
And regional settings is EQUAL in global settings !!!!!!
Sam Hobbs15y ago
My guess is that the message is saying that the decimal separator is the same as something else but I don't understad what it means by "text file separation". My guess is that the file would not be created with that inconsistency. So you need to determine what the characters were that were used to create the CSV file and then specify those characters for reading the file.

I assume that the locale setting for the system that the error occurs in is set to use a "," (comma) as the decimal separator. So it makes sense that that would be a problem. If the file was created using "." (period) as the decimal separator then you need to tell OLEDB to use the correct decimal separator.

If you can change the way the file is created, I suggest using a delimited text format iinstead of CSV. If the data will never have tab characters in it then you can use a tab-delimited format. If the data might have tab characters in it then some other character could be used as a delimiter.

Finally, note that there are other ways to read CSV and tab-delimited text files. There are a few articles in this web site that suggest aternatives; I wrote one of them.
Suthish Nair15y ago
Its English (UK) or English (US) on both system. Try changing to English (US) and the decimal separator from "comma" to "dot" or ";" or the one you using. try this blog: http://www.mrexcel.com/forum/showthread.php?t=331918
Janis Peksa15y ago
I'm using .mdb file it is access.
And regional setting is not doing anything.
I already tried everything with regional settings.
Dorababu Meka15y ago
Check the Regional Settings in Control Panel: One of the things you can set is the list separation character. The error message sounds like this could be the case. Since Excel respects this setting for CSV files and your code mentions Excel somewhat... give it a try?

Make sure they match.
Standard (US) is ,.
for others it change so try as per your other wise it can lead to subtle errors like the one you're having

For further reference check here

http://blog.van-eerde.net/post/2011/05/17/Text-file-specification-field-separator-matches-decimal-separator-or-text-delimiter.aspx
Janis Peksa15y ago
Same problem in VB.
Can someone help me ?
Tried everything from Google...
Janis Peksa15y ago
I tried that but nothing happends.
In regional settings I change "List seperator" and no changes.
It's delimits by default or smth with ";" on my PC.
But on others it's shows error u can see it on pic.
Suthish Nair15y ago
Which delimiter you are using,try.. FMT=Delimited(x) - File is considered as a delimited file with delimited character 'x' or '.' or '|'.
Janis Peksa15y ago
I already wrote that regional settings is EQUAL!
Manish Tewatia15y ago
Check you regional settings may be because of that the error comes....
Janis Peksa15y ago
Suthish Nair15y ago
Am not able to view the image, Firewall restriction :(