Importing DBF (FoxPro) Files

• a_kuniyoshi

  SSC Veteran

  Points: 269

  More actions

  December 4, 2002 at 10:34 am

  #105304

  Hello again,

  Now, I have other problem:

  I want to import some dbf (foxpro) files to SQL Server 2000 and I want to choose the rows that are inside a

  specific date range. To do this, I'm using, inside the DTS, the Transformation Data Task.

  I chose the Other ODBC Connection and, if I wouldn't put the date field in the criteria, everything is fine.

  If I put, a error occurs.

  I use the following query :

  Select number, emission

  from NF

  WHERE (emission = { d getdate()-60})

  and I receive the following error:

  [Microsoft] [ODBC Visual Fox Pro Driver] Syntax error or access violation.

  Somebody could help me?

  Thanks,

  Adriana

• don1941

  SSCarpal Tunnel

  Points: 4183

  More actions

  December 4, 2002 at 11:21 am

  #443120

  IF you're trying to do date arithmetic, your syntax is slightly off

  Trythis

  Select number, emission

  from NF

  WHERE (emission > dateadd(dd, -60, getdate())

  To get everything within the past 60 days.

• cwedgwood50

  SSCommitted

  Points: 1751

  More actions

  December 11, 2002 at 7:58 pm

  #444188

  I have found the foxpro drivers to be a real pain especialy with date fields.

  Question: Is the code you posted the code you originally typed in or has it been modified by the sql engine?

  You can type perfectly valid sql code into the DTS, but if you then test the code within the DTS it will replace some parts of the code with code that has curly brackets like that which you posted. If you then try to run this code again you will get an error like the one you describe.

  The solution I use is to write my sql in notepad, paste into dts to test, and re-paste before saving DTS.