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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS import question

Status
Not open for further replies.
jaylou

jaylou

Programmer
Feb 17, 2005
70
US
Is there a way to import all DBF files in a folder into SQL 2000 tables without naming the file to be imported?

I have a folder where all .DBF files have DWxxxxx.DBF format.
Can I create a DTS job to copy all those files into a table?

TIA,
Joe
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
SSMS question 1
Replies
4
Views
1K
Sana Shazadi
S
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
677
Chris Miller
Chris Miller
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
460
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
the goal mfrom asking question is t
Replies
0
Views
250
ahmedsa2018
ahmedsa2018
bmacbmac
  • Locked
  • Question
How to import plain text from Word doc to SQL 1
Replies
4
Views
570
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top