Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ignore last post, new question

Status
Not open for further replies.
mccafferypaul

mccafferypaul

Programmer
Oct 21, 2003
3
0
0
GB
i have made a database and added a table but is there a way of reading data from a txt file to fill the table?
 
Sort by date Sort by votes
Yes, several options:

- BULK INSERT
- DTS
- bcp

All the information on these is in Books Online. Look up the "Importing and Exporting Data" topic.

--James
 
Upvote 0 Downvote
In your previous post you said that you are using php perl sql server. This is a Microsoft SQL Server forum, so you may not be able to get the correct answers to your questions.



Hope This Helps!

Ecobb
- I hate computers!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Hello I am new to a new organizatio
Replies
1
Views
48
johnherman
johnherman
grnzbra
  • Locked
  • Question
Installing new Provider 1
Replies
2
Views
52
grnzbra
grnzbra
dgillz
  • Locked
  • Question
SQL 2016 and SQL 2008 R2 Compatibility Question
Replies
1
Views
33
simian336
simian336
dvannoy
  • Locked
  • Question
DateDiff Question 1
Replies
2
Views
31
dvannoy
dvannoy
dexterdg
  • Locked
  • Question
SQL SERVER: Query to get the last instance of an ID but return the first instance of that ID
Replies
2
Views
64
dexterdg
dexterdg

Part and Inventory Search

Sponsor

Back
Top