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.

 All Forums
 Other Forums
 Other Topics
 How to import DBF file using SQL

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=164
http://www.sqldts.com/

Go to Top of Page
   

- Advertisement -