How to read Semicolon seperated CSV File (German Cultured
-
Hi all I have a problem in processing Semicolon <;> seperated CSV file Web server Locale "en-US" CSV file Locale "de-DE" i will not be able to use "Microsoft text driver" Is there any known solution????
Thanks & Regards Pete
-
Hi all I have a problem in processing Semicolon <;> seperated CSV file Web server Locale "en-US" CSV file Locale "de-DE" i will not be able to use "Microsoft text driver" Is there any known solution????
Thanks & Regards Pete
Can't you just open the file, read it line by line and use the Split function to get the values?
- S 50 cups of coffee and you know it's on! A post a day, keeps the white coats away!
-
Can't you just open the file, read it line by line and use the Split function to get the values?
- S 50 cups of coffee and you know it's on! A post a day, keeps the white coats away!
I need to query the CSV file... there can be semicolons in the content also, so split will not help... i need to execute SQL Queries on the file using ADO..
Thanks & Regards Pete
-
I need to query the CSV file... there can be semicolons in the content also, so split will not help... i need to execute SQL Queries on the file using ADO..
Thanks & Regards Pete
Good luck, bro. :laugh:
- S 50 cups of coffee and you know it's on! A post a day, keeps the white coats away!
-
I need to query the CSV file... there can be semicolons in the content also, so split will not help... i need to execute SQL Queries on the file using ADO..
Thanks & Regards Pete
As per I know, if comma is there in your data you must write like "data1,data2" inside your CSV file, so that it takes it as single data.
Abhishek Sur
