sending query result to text file

S

s_wadhwa

Hi,

I'm converting a .mdb application to .adp format. In .mdb application I
have a button which sends a query(join of 3 tables) to .txt file
through transfertext of Docmd.
I'm not able to use this transfertext in .adp format. As I have
converted the query to view in SQL Server and transfertext is not
understanding the view name in

DoCmd.TransferText A_EXPORTDELIM, , "vFDXQryWWWRoomExport",
"c:\temp\wwwroom.txt"

error says The action or method requires a table name argument.

If anyone knows how should I get rid of this problem. Any suggestions
are welcome.
Thanks,
Shalini
 
S

Steve Schapel

Shalini,

The only thing I can notice about your code is that A_EXPORTDELIM should
be acExportDelim

I have never used an ADP so I don't know. Perhaps you could use a
Make-Table query to put the data into a temporary table in the local
mdb, and then use that as the basis of the TransferText.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Data 1
Import text file with macro - Invalid argument (Error3001) 0
Importing text file with append 1
macro with new file name 1
schema to text file 7
Importing what file name? 3
Find a Dir and File 3
New named File macro 1

Top