Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2003-07-15 : 08:29:26
|
ANTeam writes "I hv dbf file and i want to insert all the records in that file into a table which i had create it in the database...How to insert all the records in that table using Sql Statement>>>???I am using Oracle SQL* pluse 8...windows NT server" |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-15 : 08:32:28
|
Well, we're a SQL Server site, you might have better luck with an Oracle site. However, if you have SQL Server 7.0 or later available, you can use Data Transformation Services to directly transfer data to and from the DBF file and Oracle. You can find out more about DTS from here:http://www.sqlteam.com/FilterTopics.asp?TopicID=164http://www.sqldts.com/ |
|
|
|
|
|