Trying to create a dynamic named csv report....

[Guest]

Hi, I am trying to create a report using 6 columns separated by commas to
save onto a specific directory on our server using a distinct file name for
each report run. In theory, I understand the concept but having quite a bit
of trouble actually doing this using Access. I am using Access 2003. Any help
appreciated.

Thanks,
Cindy

 

[jahoobob via AccessMonster.com]

How are you creating a report with 6 columns separated by commas. Reports
are displays of data, not the actual data.
If, on the other hand, you have table with six fields and you want to save
the data to a .csv file select File, Export and pick the file type to export.
Follow through with the wizard and select the destination path and file name
in the last window.

 

[Guest]

I have a query my report runs from. I have taken the chosen fields and
concatenated them with commas. I would like to be able to run this report,
save it to a specific directory using a distinct value from this query as the
file name. I don't want my users to have to manually do the extraction. This
report will be created at least 100 times a day and contain anywhere from 1
to 7 lines of data. It will be picked up by another non-Access application
for further processing. Am I going about this process wrong? Is there any way
to do this automatically using a button on a form? Do I even need to create a
report?

 

[Larry Daugherty]

If it were mine to do I'd determine the desired file name and then
open that Filename.csv for write and write the query results as comma
separated values to the file. That would meet your required result to
a T. However, it's all done with the plain old BASIC file I/O, no
graphic help. Once you've got the design done it should be just a
matter of doing whatever it is that you do to get the new values and
then click a button to run your procedure.

Look for "Write #" statement. There is at least one example that
whould get you going. Post back if you have questions.

HTH