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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 populate tables based on a dbf file

Author  Topic 

qman
Constraint Violating Yak Guru

442 Posts

Posted - 2007-08-28 : 15:29:44
I have created a new database using SQL 2005 and want to create and populate some tables bases on an external .dbf file. Can someone please tell me how to accomplish this?

Much thanks!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-28 : 15:40:03
Use the IMPORT WIZARD that comes with SQL Server 2005.
Right click the table, click Tasks and then Import.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -