ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> exporting customer data
http://www.istechforum.com/YaBB.pl?num=1231371782

Message started by eti on 01/07/09 at 16:43:02

Title: exporting customer data
Post by eti on 01/07/09 at 16:43:02

Is there a way to export the customer name address and contacts into excel spreadsheet?

Title: Re: exporting customer data
Post by Kelloggs on 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 :P

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

Title: Re: exporting customer data
Post by kevind on 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.

Title: Re: exporting customer data
Post by GasGiant on 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.

Title: Re: exporting customer data
Post by RPCAdmin on 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.