MS access 2003 CSV export

Associate
Joined
18 Oct 2002
Posts
858
Location
Cheshire
ok, here is what i go.... I got a macro that calls a queery.... I want to save the results of the queery to a CSV file....

Except the CSV file has to be in spacific dir.... as in....
todays date is the 16/01/2008 so....
../2008/January/JC-2008-01-15.csv


so, I use the macro command OUTPUT but it doesn't let me save it as a CSV and I can't figure out how to get the date in their....

any help appreciated...

Thanks
 
Back
Top Bottom