How do I save an access query to a floppy?

I'm new at Access. I need to take a copy of a query I have for a test run.
How do I make a copy to take with me for them to use?

Copy the text from SQL view of the query and paste it to a text file.
Reverse the process on the other end.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"P2PNewAccessUser" wrote:
| I'm new at Access. I need to take a copy of a query I have for a test
run.
| How do I make a copy to take with me for them to use?

As my display name indicated I am a new user of Access. I need to know step
by step how to do this. I went in and saw the SQL view but this looks like
computer language and not the file. When I do a save as it is foreign to me
as how I can save this or the query to ANY file. HELP!

"Dave Patrick" wrote:

Copy the text from SQL view of the query and paste it to a text file.
Reverse the process on the other end.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"P2PNewAccessUser" wrote:
| I'm new at Access. I need to take a copy of a query I have for a test
run.
| How do I make a copy to take with me for them to use?

Yes that's correct what you're looking at is the SQL that's makes up the
query. Just copy the text of the SQL and paste it into a text file. Then
reverse the process on the other end. That is copy the text from the text
file, you saved, and paste it into the SQL view of a new query on the other
end.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"P2PNewAccessUser" wrote:
| As my display name indicated I am a new user of Access. I need to know
step
| by step how to do this. I went in and saw the SQL view but this looks
like
| computer language and not the file. When I do a save as it is foreign to
me
| as how I can save this or the query to ANY file. HELP!

On Mon, 26 Sep 2005 18:49:03 -0700, "P2PNewAccessUser"
wrote:

I'm new at Access. I need to take a copy of a query I have for a test run.
How do I make a copy to take with me for them to use?

Are you trying to save the *query* - which (as is discussed in this
thread) is a SQL language set of commands - or are you trying to save
*the data displayed by running the query*? They are two different
things!

If you want to save the data, open the Query in datasheet view and
select File... Export from the menu. Choose the appropriate type of
export file (text, Excel, etc.) This will create a file containing the
data from your current database.

Exporting the SQL view of the QUery will let you rerun the query in
some other Access .mdb file, using the data in *that* file.

John W. Vinson[MVP]

John,

I'd like to give you a big hug!!!!! You got to the bottom of what I was
really needing!! I sometimes don't know exactly how to word what it is I'm
trying to do. I guess I should have explained what I was doing. I was
trying to make a copy of the spreadsheet (query) to take to someone who is
going to test it at a mailing service. They use our Excel file at the moment
but our organization wants to use Access instead of Excel because of its
capabilities of "relationships" (here we go again with terminology!) and
having to make a change in only one location for all our data knowledge.

Thanks loads again!!!

ABH

"John Vinson" wrote:

On Mon, 26 Sep 2005 18:49:03 -0700, "P2PNewAccessUser"
wrote:

I'm new at Access. I need to take a copy of a query I have for a test run.
How do I make a copy to take with me for them to use?

Are you trying to save the *query* - which (as is discussed in this
thread) is a SQL language set of commands - or are you trying to save
*the data displayed by running the query*? They are two different
things!

If you want to save the data, open the Query in datasheet view and
select File... Export from the menu. Choose the appropriate type of
export file (text, Excel, etc.) This will create a file containing the
data from your current database.

Exporting the SQL view of the QUery will let you rerun the query in
some other Access .mdb file, using the data in *that* file.

John W. Vinson[MVP]

On Tue, 27 Sep 2005 14:01:03 -0700, "P2PNewAccessUser"
wrote:

John,

I'd like to give you a big hug!!!!!

g Hugs is nice. Glad I was able to help.

You might want to export as Excel then.

John W. Vinson[MVP]