Possible To Email A Query?

  • Thread starter Thread starter Victoria
  • Start date Start date
V

Victoria

Hello,
Is it possible for me to email a query to others for them
to put in their database instead of them having to create
it for themselves?

Thank you,
Victoria
 
There might be a much easier way to do this, but what I do
is go to SQL view on the query I want to send, then copy
all of the text, paste it into either a text file or
directly to email. When the person receives it they can
just paste it into the SQL view on their machine and go
from there.

Like I said, it works for me but there may be
an "official" way that's easier.

KG
 
Thanks, KG! This works. I do wonder if there's another
way, but this really does work and it's easy.

Thanks again!
 
A method I have used successfully was to create a blank export database.
Open the database that has the query/report/table/module/forms/macros/pages
you wish to export
Highlight the query/report/table/module/forms/macros/pages
Click File Export
Select the export database and click Export
A text box will appear identifying the
query/report/table/module/forms/macros/pages to export
Click OK
Email the database to the end user who can save it to some location then
user Import command to get what was sent.

This method is a little longer but the pro's are
You can export query/report/table/module/forms/macros/pages
Emailing SQL can have problems with line breaks entered by the email process
Users not familiar with queries don't necessarily know how to cut and paste
code - this bypasses the problem
Importing can be done in one transaction thus they can import all the
objects in the database in one go

Con's of this process
You need to delete all objects in the export database if not using them for
this particular export
If using MS Outlook or others then the database may not be an allowed
attachment
You can only export one object at a time to the export database
Recommend you compact the export database before sending


HTH
Grant
 
If your using Outlook you can probably open an instance of it and mail it that
way.
(e-mail address removed)
 
Back
Top