Bulk Insert Foxpro file

• jaybmehta

  SSChasing Mays

  Points: 637

  More actions

  December 5, 2002 at 12:04 am

  #105383

  I have a foxpro file (.dbf).

  I want to do "Bulk Insert" command in the procedure, but i am not able to find out the fieldterminator, rowterminator, of the Foxpro file. can anyone tell me the syntax for doing the bulk insert into one table from a Foxpro file which lies on my disk.

  Any help would be very heelpful to me

  Thanking in advance.

  Regards

  Jay

• a_kuniyoshi

  SSC Veteran

  Points: 269

  More actions

  December 5, 2002 at 3:45 am

  #443245

  I try to do this, but I gave up, because I have the same problem.

  Now, I'm using the DTS, I create a ODBC driver to access the foxpro database, a ODBC Connection, a SQL connection and a Transform Data Task to do the importation.

  I hope to help you,

  Mariko

• don1941

  SSCarpal Tunnel

  Points: 4183

  More actions

  December 5, 2002 at 7:16 am

  #443270

  Bulk insert is for a flat file. your foxpro file is going to be formatted in its data base format and not in a usable format that BI can recognize. If you can export your Foxpro table to a flat file, then you can use Bulk Insert. Otherwise, DTS will work using the ODBC connector.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  December 5, 2002 at 5:11 pm

  #443372

  Question duplicated in the following thread please see both for future reference http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8571&FORUM_ID=19&CAT_ID=3&Topic_Title=How+to+run+a+dts+package+by+a+user+who+is+not+in+u&Forum_Title=Data+Transformation+Services+%28DTS%29