By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,054 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Help needed transfering query -> CSV

P: n/a
Hi all
I'm using access 2003 against sqlserver 2000sp3 and I need to export a
'query' to a csv file. The problem I'm having is getting TransferText to
see the query. I've tried views, stored procedures and functions on the
server, but TransferText, from either vba or a macro, Will claim it cant
see any item I use except for tables.

Can someone tell me, if what I'm doing is possible, or what I might be
overlooking (like a naming convention, or an option somewhere etc)?
Thanks
Glenn
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On May 27 2004, 11:27 pm, Glenn Davy <gS***********@tpg.com.au> wrote in
news:pa****************************@tpg.com.au:
I'm using access 2003 against sqlserver 2000sp3 and I need to export a
'query' to a csv file. The problem I'm having is getting TransferText to
see the query. I've tried views, stored procedures and functions on the
server, but TransferText, from either vba or a macro, Will claim it cant
see any item I use except for tables.


If in code you can open a recordset (DAO or ADO), based on the 'query',
then you can pass it to TextExport class from
http://www.users.cloud9.net/~dfurman/code.htm, which will export it to a
text delimited file.

--
remove a 9 to reply by email
Nov 13 '05 #2

P: n/a
Thx dimitri - this sounds even more like what I really wanted to achieve.
Still puzzled why transfertext doesn't work like it used to though.

On Fri, 28 May 2004 12:22:48 +0000, Dimitri Furman wrote:
On May 27 2004, 11:27 pm, Glenn Davy <gS***********@tpg.com.au> wrote in
news:pa****************************@tpg.com.au:
I'm using access 2003 against sqlserver 2000sp3 and I need to export a
'query' to a csv file. The problem I'm having is getting TransferText to
see the query. I've tried views, stored procedures and functions on the
server, but TransferText, from either vba or a macro, Will claim it cant
see any item I use except for tables.


If in code you can open a recordset (DAO or ADO), based on the 'query',
then you can pass it to TextExport class from
http://www.users.cloud9.net/~dfurman/code.htm, which will export it to a
text delimited file.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.