How do I save an access query to a floppy?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

P2PNewAccessUser - 27 Sep 2005 02:49 GMT

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?

Reply to this Message

Dave Patrick - 27 Sep 2005 03:23 GMT

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

Signature

Regards,

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

| 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?

Reply to this Message

P2PNewAccessUser - 27 Sep 2005 03:57 GMT

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!

> Copy the text from SQL view of the query and paste it to a text file.
> Reverse the process on the other end.
>
> | 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?

Reply to this Message

Dave Patrick - 27 Sep 2005 04:03 GMT

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.

Signature

Regards,

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

| 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!

Reply to this Message

John Vinson - 27 Sep 2005 05:29 GMT

>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]

Reply to this Message

P2PNewAccessUser - 27 Sep 2005 22:01 GMT

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

> >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?
[quoted text clipped - 13 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 27 Sep 2005 22:21 GMT

>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]

Reply to this Message