Exporting to a CSV file

[Rob.Mills]

Is there a docmd or something else where I can export a query to a csv file?

 

[Jacob Mathai]

you can create a macro with transfertext and use export delimited and give the query name as the tablename.

 

[Rob.Mills]

Thank you. That's what I was looking for.

 

[Rob.Mills]

It's asking for a schema file. I've never created one of those. Can you walk me through it?

 

[Jacob Mathai]

For a CSV ouput file, I leave the Specification blank.

 

[Rob.Mills]

won't let me

 

[Rob.Mills]

well it let me do it in My Documents folder as the path to save. But not in the one I was trying. Any idea why?

 

[Randomblink]

Quick Function

Here...
I put this together...
It will run through it for you...

Click Here For A Link To A Function I Created That Does What You Are Looking For

Enjoy...
Yeah, you CAN Import/Export? But this is more fun...
...Chuckle...

Enjoy