|
Subject:
|
how to copy data from txt file
|
|
Posted By:
|
kiwibey
|
Post Date:
|
11/22/2004 11:31:56 PM
|
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
|
|
Reply By:
|
om_prakash
|
Reply Date:
|
11/23/2004 1:52:17 AM
|
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
|
|
Reply By:
|
happygv
|
Reply Date:
|
11/23/2004 1:11:15 PM
|
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
|
