Is there a way I can export just a single record from Access to Excel or to an Outlook email?
I can export, but the table goes with it. Can a single record be exported?
Thanks in advance.
Is there a way I can export just a single record from Access to Excel or to an Outlook email?
I can export, but the table goes with it. Can a single record be exported?
Thanks in advance.
Are you wanting to export this single record from a Form?
-Randy Shea
I'm a programmer, but I'm also pro-grammar!
If your issue is resolved, please use Thread Tools to mark your thread as Solved!
PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003
Yes.Originally Posted by CreganTur
Take a look at this thread- it deals with what you're looking to do.
HTH
-Randy Shea
I'm a programmer, but I'm also pro-grammar!
If your issue is resolved, please use Thread Tools to mark your thread as Solved!
PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003
Here's the easiest way:
Write a query that returns the single record.
With the query active, select File Export.
The Access dialog will be headed "Export Query 'xxxxx" To..." and let you select how you want to output it.
The resulting file will contain ONLY the results of this query.
S