Export to Access with same structure.

[Guest_imported]

Hi,
I have report like below..
CustomerName OrderID OrderAmount
Alley Cat Cycles 1151 $1234

When i export this an Access database, the table columns are
PH_1,PH_2,PH_3,PH_4,DE_Customer_Name,DE_Order_ID,DE_Order_amount
with the values
CustomerName,OrderID,OrderAmount,Alley Cat Cycles,1151,$1234

Hw do i get the data exported to Access with just the column values (preferrably thru VB Code) and also how do i
take care of things column total, page total etc such that it does not get exported.

Thanks in advance for your help.

Sammy

 

[kenhamady]

Fist suppress all sections that contain objects that you don't want to export. The column names, however, can't be controlled. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com