ranw3schools Posted November 25, 2005 Share Posted November 25, 2005 how do you perform SQL statement in a comma separated values(*.csv) file format ?I have open the connection using OLEDB, but I don't know the SQL statement Link to comment Share on other sites More sharing options...
Jerome Posted November 25, 2005 Share Posted November 25, 2005 I don't think you can query directly a .csv file... but what you still can do is save the .csv as a .xls file and then query this excel file... like here : http://w3schools.invisionzone.com/index.php?showtopic=612 Link to comment Share on other sites More sharing options...
vijay Posted November 26, 2005 Share Posted November 26, 2005 Hi, :)For that u will have to Create Systenm DSNAnd that Using that System DSNAs Simple What ever u write in Sql like that U can wite and use with csv alsoI did not try Otherwise Using DTS U can Store that CSV to Some Table in MDB(Access)Or SQL Sever TableAnd U can use itOk?And By Directly U can get the Solution From CSV and U will get the output then plz message me by PM(Personal Messanger)ThanxVijay Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now