Import CSV files to SQL

[johnkim_ct]

I have SQL 2000 running under windows 2000 server.

Question:
I'm receving CSV files from the field.
I would like to built SQL database from daily CSV files. I've been doing this manually however, is there anyway I can do this task automactically so that once new daily CSV file ~200KB appear in the folder, progarm automatically insert recent file to SQL database... Do I need to write VB progarm for this? Please help...

[MAK]

u can write a dts package and schedule it for every 15 min daily. write activex script to check the status of existance of file. if the file exist the dts will import it. and rename the csv file to old.

refer: www.sqldts.com

[rmiao]

You can build a dts package to load data and set up schedule to run the package.

[johnkim_ct]

Thank you for the prompt reply. I have no background in progarming nor time to do it by myself. Furthermore, this is project have to finised by end of April. I'm looking for contractor who could come in and do this programming for Compnay located in zip code 06810. Do you guys know anyone?

[MAK]

I can do it for you. I can send the dts package and complete instruction set.

email me the details. we will discuss
.

mak_999@yahoo.com