Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

Find more posts tagged with

English

Monarch

Accepted answers

All comments

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

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

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.

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

Mo Abdolrahim

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

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

Hi Janet,
Use Monarch classic, Open database, select DBF Files (*.dbf)
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)

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