Hello!
This may be not a right place to post co'z this question is related to MS-Sql 2000 but i hope someone help me its urgent plz...
My requirement is that i want to upload a file from the front end which is developed in PHP and after uploading it i want to read that file and insert data into the database but the data is in bulk can be more then 50,000 plus rows if i open it and read turn and insert turn by turn then IIS display CGI Timeout out...so that seems not possible after that i found a help full quesy "BULK INSERT" and "BCP" command line utility its working fine but problem is occoured when i added some more columns in table
Like there is 10 columns in the txt file which have data and now my table have 16columns before its working very fine but after increasing the columns in db both the "BULK INSERT" and "BCP" started probleming both are not inserting into specific columns they read 2lines from file and insert it in one row...
Any one have any other better option or know about this problem plz help me its urgent....
Thanks,
zohaib.
Bulk Data
Moderator: General Moderators