|
|
 |
| ASP Forms As of Oct 5, 2005, this forum is now locked. Please use "Classic ASP beginner" at http://p2p.wrox.com/forum.asp?FORUM_ID=54 or "Classic ASP Professional" http://p2p.wrox.com/forum.asp?FORUM_ID=56 instead. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the ASP Forms section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
November 23rd, 2004, 12:31 AM
|
|
Authorized User
|
|
Join Date: Oct 2004
Location: Kuala Lumpur, Wilayah Persekutuan, Malaysia.
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
how to copy data from txt file
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
|
November 23rd, 2004, 02:52 AM
|
|
Friend of Wrox
|
|
Join Date: May 2004
Location: India
Posts: 563
Thanks: 0
Thanked 14 Times in 14 Posts
|
|
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 |
November 23rd, 2004, 02:11 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,477
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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 |
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
