jdy0803
Well-known member
I try opening Excel file using OleDbConnection like following.
	
	
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
This works fine in English (United States) or other date format.
But, if I change date format to Bulgarian (Bulgaria), following error occurs at cn.Open.
		
		
	
	
Bulgaria uses simillar date format to Czech.
It works fine if I change date format to Czech but not Bulgaria.
I can't figure out this problem.
Can anybody give am some advice?
	
		
			
		
		
	
				
			
			
				VB.NET:
			
		
		
		cn = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0; Data Source=C:\Test.xls;Extended Properties = ""Excel 8.0;HDR=Yes""")
cn.Open()   '<===== here error occurs!
.
.
.This works fine in English (United States) or other date format.
But, if I change date format to Bulgarian (Bulgaria), following error occurs at cn.Open.

Bulgaria uses simillar date format to Czech.
It works fine if I change date format to Czech but not Bulgaria.
I can't figure out this problem.
Can anybody give am some advice?
 
	 
 
		 
 
		