hi everybody,
i need copy data from txt file to sql server database...
so how can i copy the data from the txt file then capture by a variable then insert in to database.......
anybody have idea about this please help me.....
thank you so much...
also thanks for this p2p forum...
it help me a lots....

bey

you can use fileSystemobject to read the text file and insert the data in SQL server.
http://www.eggheadcafe.com/articles/20030627b.asp

Om Prakash

Hi Bey,

Is the data formatted in the text file? If so is the table structure similar to that of the data structure of the text file? If so, you may check out this thread, that should be helpful.

Import data in SQL

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection