How to copy database search results to a text file?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

wango

Thread Starter
Joined
Nov 13, 2001
Messages
74
How do I copy database search results to a text file?

I was trying this but appaently it did not fly.

select * from categories << f:\myfile.txt
 
Joined
Oct 14, 2001
Messages
2,218
Hello... Do you know how to Cut & Paste? Can you highlight it by running the mouse over it while holding down the left key?

If so do that & then either right click & copy or .. you can hold down Ctrl & click C.

Then open a notepad & set the cursor there & hold down Ctrl & click V .......or right click & paste.

then go to file & "save as" ... name the file & select at the top which directory & then click save


That should do it unless its the format that you can't Copy from... then you have to center it to most visible view & do a print screen.

Savvy :) hope that helped
 
Joined
Jul 29, 2001
Messages
21,334
You have the pipe command going the wrong way anyways....LOL It needs to go >> the other way. I do not believe a DOS pipe command will get you what you want, and I do not believe you can put this in a select statement either. You never stated what application you were using, If it's Access you can do this in a VB function on a form or with an action button.
 

wango

Thread Starter
Joined
Nov 13, 2001
Messages
74
Thanks for the reply. I am doing this in the "SQL Server Query Analyzer". If I am in VB oe VC, I can very easily send the info to a file; but I happen to vbe on a machine that does not have any of those applications.

Wango
 
Joined
Oct 10, 2001
Messages
186
If you haven't figured it out already, right-click the results window in the grid there. You should then have the option to export the results.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top