Importing csv file into SQL Server

mainul

Member

Join Date: Sep 2006

Location: Dhaka, Bangladesh

Posts: 53

#1: Jan 17 '07

Hello guys,
i have a web application developed in php+SQL Server 2000. i need to import data from csv file into the database. i can do it using array. but the problem is the table structure and the sequence of the data in the csv file are not in same sequence. for example i have country of origin in the first row of the table but in the csv file it is in the 5th row. that is array[0] should be assign to 5th row and many of the data is in scattered way. can anyone tell me how to solve it.

best regards,
Mainul

« previous question | next question »

Similar PHP bytes

importing into sql server 2005 from visual basic 2008 not creatingtable on the fly (answers)
import excel sheet into a sql server table (answers)
Importing XML data into SQL Server 2005 (answers)
Flat file parsing into SQL Server 2000 (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,449 network members.