Import and Export

• kiruba-370649

  Old Hand

  Points: 372

  More actions

  March 24, 2007 at 8:02 am

  #119261

  hai all,

  How i can import .dbf file into sql server 2005

  Kindly suggest me

  Thanks in advance

  Regards

  Kiruba

   

   

   

   

• kb

  SSC Journeyman

  Points: 85

  More actions

  March 24, 2007 at 2:39 pm

  #696766

  SELECT *

  INTO dbo.YourTableName

  FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=C:\Path;Extended

  properties=dBase 5.0')...[FileWithoutExtension]

  --

  kb

  ^{Microsoft Knowledge Base Articles Monitoring | Apple Knowledge Base Articles Monitoring}