Re: exporting selected record to Excel spreadsheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: tina (nospam_at_address.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 17:40:03 GMT

AFAIK, there is not. generally speaking, Access tables merely hold data,
they're not used to manipulate it.
suggest you add a third field to the table called Picked, with DataType
Yes/No. in the open table, checkmark the records you want to export. then
build a query using all three fields, and set the criteria of the Picked
field to True. you can export the query to Excel, and only the checkmarked
records will be exported.

hth

"wsc4597" <anonymous@discussions.microsoft.com> wrote in message
news:72C17B85-104E-4D41-B802-D46B8F230B30@microsoft.com...
> I'm trying to help out of of my customers, and am hoping someone can help
me! I am a very new user of Access.
>
> I have created a very simple table in Access 2003, consisting of an item
number and a description of each item number. When finished, this table will
probably have about 100 records. My customer wants to be able to select a
specific sub-group of records and export them to an Excel spread***, where
I will enter variable pricing and other information for further data
manipulation. Does Access support a multi-select function similar to
Excel's, where I can hold down the Ctrl key and only select certain
fields/rows/columns? I tried using Ctrl but it didn't work.

Quantcast