help with DoCmd.TransferText

[axism]

Hi, I am trying to extract a view from sql server to text file using the follow, but doesnt seem to be working for me.

DoCmd.TransferText acExportFixed, , "queryExtractData", "c:\mytest\test.txt"

can someone give me some help? thanks

 

[PHV]

but doesnt seem to be working for me
Any chance you could elaborate ?
Please, feel free to carefully read the second FAQ in my sig.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[axism]

Hi, I created a view name queryExtractData, which returns a few columns in some tables and I am trying to export the result of the returned columns to a text file using DoCmd.TransferText. I have a button and the code above was what i typed in the on click event for button. And it's saying queryExtractData is not define when i click on button.

 

[PHV]

If queryExtractData is a sql server view you have to link an access table to it and export this linked table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[axism]

how do i link it to an access table or export it to linked table?

 

[PHV]

menu Files -> External data -> Link table -> ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[axism]

hmm is that in access 2000 or this part of the menu for adp files? I can't see link table in menu. there is a Export, Get external Data -> Import under my Menu File. But, don't see link table anywhere

 

[PHV]

You're playing with adp, not mdb ?
So, please, post in the adp dedicated forum.

 

[axism]

btw i am able to export a table, just not query.