🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Data Prep and DBF files

User: "Janet_21505"
Altair Community Member
Updated by Janet_21505

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
------------------------------

Find more posts tagged with

Sort by:
1 - 6 of 61
    User: "CPorthouse"
    Altair Employee
    Updated by CPorthouse
    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
    ------------------------------
    User: "Janet_21505"
    Altair Community Member
    OP
    Updated by Janet_21505

    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
    ------------------------------
    User: "Janet_21505"
    Altair Community Member
    OP
    Updated by Janet_21505

    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
    ------------------------------
    User: "Janet_21505"
    Altair Community Member
    OP
    Updated by Janet_21505

    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
    ------------------------------
    User: "Mo Abdolrahim"
    Altair Employee
    Updated by Mo Abdolrahim
    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
    ------------------------------
    User: "Janet_21505"
    Altair Community Member
    OP
    Updated by Janet_21505

    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
    ------------------------------