Read CSV data file into MS SQL SERVER 2000

Yong Yau

The case like this. User can create their CSV data file from their SAP application & SAP server. For my side, i am developing a system which will let user browse to the CSV data file which user save to their thumb drive, floopy disk even their local pc. when they select their prefer CSV file, user can click on a button to import the CSV data into my database on my SQL server. Any idea for me to perform this import action including while importing i can checking and filtering out those unnecessary CVS data. Thank for response!!!

_AK_

This depends how you want to store the data into the database.

Best Regards, Apurva Kaushal

Yong Yau

Let say i will not import all the data from the CSV file selected by the user as while importing the data i will perform some checking to pick up those related CSV data to be store into my table in my SQL server database. I am stuck in the coding how will it be for the code as after user click the import button on my system, the importing and filtering will be take action. After successful importing and filtering, the data will store in the database. Please advice.

_AK_

you can read the CSV file and then can store it in some array and then you can filter it and finally store it in the database. In which step is the problem. :)

Best Regards, Apurva Kaushal