ISTech Support Forum - exporting customer data

Welcome, Guest. Please Login.

	05/24/25 at 18:09:06 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›

Pages: 1

exporting customer data (Read 1033 times)

eti Browser I love YaBB 1G - SP1! Posts: 29	exporting customer data 01/07/09 at 16:43:02 Is there a way to export the customer name address and contacts into excel spreadsheet?
Back to top	IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: exporting customer data
Reply #1 - 01/08/09 at 08:36:01

You can use the Pervasive Control Panel

Select the Database, select table BKARCUST, right click and select Export Data

Then you can export the entire table or use a query, then open the text file with excel Tongue

SELECT
BKAR_CUSTNAME,
BKAR_ADD1,
BKAR_ADD2_1,
BKAR_CONTACT_1,
BKAR_CITY,
BKAR_STATE,
BKAR_TELEPHONE_1,
BKAR_FAX_PHONE
FROM BKARCUST
where length( BKAR_CUSTNAME) <> 0"

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male

Re: exporting customer data
Reply #2 - 01/08/09 at 08:50:49

If you are more comfortable working from Excel, you can pull the same data right into an Excel sheet
from the BKARCUST table using Excel's "Data->Import External Data" functions.

You will need an ODBC data source defined for your DBA tables.

Select "Data->Import External Data->New Database Query" and just follow the wizard.

I just did it while typing in this post and it literally took a minute.

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: exporting customer data Reply #3 - 01/08/09 at 09:02:41 Or you could just use DE-A to export the whole table (BKARCUST) to a delimited (D) text file and then import that into Excel.
Back to top	IP Logged

RPCAdmin Active Member Please save me from the Users!!!!!!! Posts: 521 Gender:	Re: exporting customer data Reply #4 - 01/08/09 at 09:36:24 Absolutely! DE-A works great - simple and opening it in Excel as a comma delimited also works great. Just delete the columns you don't need and you've got what you need.
Back to top	Mike Nessen Sr. Engineer/IT Manager/Anything else I need to be EVO-Erp Build (always the latest) Client/Server Pervasive 2000i on NT4 Server 15 users IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›