I have Visual Basic 6.0 and Crystal Reports 5.0.

I have a Crystal report already created and associated with its data source.

I need to program VB to run the report (to get refreshed data) and export
the data into an Access97 database via ODBC. I have been able to get my
commands to work using PEOpenEngine, except not to automate the database
the report data goes to. In other words, it runs the report, but prompts
the user to choose the SQL DataSourse and then Select the Database. My last
command is :
crPEExportToODBC (Job, "ODBCExportTest" + chr(0), "" + chr(0), "" + chr(0),
"SampleTable" + chr(0))

If the "SampleTable" part is where I name the table I want the data to go
to, where is the part where I name the database type and name??

Anybody help with this?

(My search at Seagate website did not provide any specific/help)