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
------------------------------
Answers
-
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
------------------------------
0 -
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
------------------------------
0 -
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
------------------------------
0 -
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.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
------------------------------
------------------------------
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
------------------------------
0 -
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
------------------------------
0 -
In this situation, I think Classic is the better choice. Thanks, Mo.Mahmoud said: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 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
------------------------------
0
Altair Employee