create output delimited file

[GShen]

Need to be able to create an delimited text file using ACCESS 2000 as front end and SQL 2000 as backend. I tried Docmd.outputto but it does not allow for a delimited output format. I tried Docmd.Transfer text but I cannot call a stored procedure from it. It says you can create a query and use that name but I am using and ADP. I would assume they are talking about creating a query using an MDB. Does anyone know of anything which does this?
I could always have the stored procedure create a table and then use the transfer text to delimit the file but I was trying not to create a work table.
Much appreciated.

 

[ETID]

Will a linked table or query work?

I.E. from Access

File> get external data> Link tables...


follow the wizard.

 

[GShen]

can't use a query. This a ADP. After reading my question, I could have been a little more descriptive.
I have a stored procedure which is going to create my data.
I need to have the results in a comma delimited file. Other than having it create a table and do a transfer text, I do not see anything which will do this.
Hopefully, this is clearer.
Thanks,