CSV file as data source

[otter42]

I am using a CSV to drive a CR using ODBC DSN - its great and very quick.

The data is generated into a different CSV filename each night by a VB6 app. (the file has the date in the name so I can see historic data)

I need to change the DSN datasource from within the VB6 app to point to the newly created CSV file so everything is sitting on th printer first thing in the morning.

I'm having troubles pointing to the newly created csv file.

 

[IdoMillet]

Use your VB application to export to both the "properly" named file as well as to a fixed name file (overwriting the previous day's export).

Now you can rely on a fixed ODBC data source since the fixed filename doesn't change.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com