Data Prep and DBF files

Janet_21505
Janet_21505 Altair Community Member
edited September 2020 in Community Q&A

I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password. 

Janet ​

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
5403490215
------------------------------

Tagged:

Answers

  • CPorthouse
    CPorthouse
    Altair Employee
    edited September 2020
    Can you open as DB2 (dBase II)?

    ------------------------------
    Chris Porthouse
    Professional services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------
  • Janet_21505
    Janet_21505 Altair Community Member
    edited September 2020
    Chris Porthouse said:

    Can you open as DB2 (dBase II)?

    ------------------------------
    Chris Porthouse
    Professional services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------

    If I open as a DB2, Data Prep wants to set up a connection.  This is just a simple .dbf file sitting on the network. 

     



    -------------------------------------------
    Original Message:
    Sent: 9/28/2020 11:06:00 AM
    From: Chris Porthouse
    Subject: RE: Data Prep and DBF files

    Can you open as DB2 (dBase II)?

    ------------------------------
    Chris Porthouse
    Professional services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------
  • Janet_21505
    Janet_21505 Altair Community Member
    edited September 2020
    Chris Porthouse said:

    Can you open as DB2 (dBase II)?

    ------------------------------
    Chris Porthouse
    Professional services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------

    I opened the dbf in Excel, so I now have an excel file.  I only work with this file once a quarter.  Not critical, but was curious. 

     



    -------------------------------------------
    Original Message:
    Sent: 9/28/2020 11:06:00 AM
    From: Chris Porthouse
    Subject: RE: Data Prep and DBF files

    Can you open as DB2 (dBase II)?

    ------------------------------
    Chris Porthouse
    Professional services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------
  • Janet_21505
    Janet_21505 Altair Community Member
    edited September 2020
    Chris Porthouse said:

    Can you open as DB2 (dBase II)?

    ------------------------------
    Chris Porthouse
    Professional services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------

    I opened it as a text file and it worked, although not sure that is the best choice.  So far I don't see anything wrong with it.

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-28-2020 11:06 AM
    From: Chris Porthouse
    Subject: Data Prep and DBF files

    Can you open as DB2 (dBase II)?

    ------------------------------
    Chris Porthouse
    Professional services
    Altair
    ------------------------------

    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------
  • mabdolrahim_1357
    mabdolrahim_1357
    Altair Employee
    edited September 2020
    Hi Janet,
    Use Monarch classic, Open database, select DBF Files (*.dbf)
    image
    You can either port the table to DPS and modify your data in DPS or you might be able to modify it in classic.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Altair Engineering
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------
  • Janet_21505
    Janet_21505 Altair Community Member
    edited September 2020
    Mahmoud said:

    Hi Janet,
    Use Monarch classic, Open database, select DBF Files (*.dbf)

    image
    You can either port the table to DPS and modify your data in DPS or you might be able to modify it in classic.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Altair Engineering
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------
    In this situation, I think Classic is the better choice.  Thanks, Mo.

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-29-2020 07:31 AM
    From: Mahmoud Abdolrahim
    Subject: Data Prep and DBF files

    Hi Janet,
    Use Monarch classic, Open database, select DBF Files (*.dbf)
    image
    You can either port the table to DPS and modify your data in DPS or you might be able to modify it in classic.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Altair Engineering
    ------------------------------

    Original Message:
    Sent: 09-28-2020 10:29 AM
    From: Janet Grimsley
    Subject: Data Prep and DBF files

    I have an application that outputs to dbf.  How do I get the dbf into Data Prep?  I have tried importing with the Excel and Access channel, but DP does not recognize either.  Tried ODBC, but that wants a user and password.

    Janet

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    5403490215
    ------------------------------

Categories