Monthly Archives: January 2006

Import external data into SQL server: from CSV or TEXT file

3. csv fileSuppose we have a csv file Animal.csv under c:\test. It contains the following records:Yellow    12       345     DogBrown      3       222     DogBlack      4        55     Cat For csv or text, a schema.ini file is required to define the schema for each … Continue reading

Posted in SQL server | Leave a comment