File | Get External Data | Link Tables will let you create a linked table
that will pull its data from your Excel spreadsheet. Join that linked table
to your larger existing table, and you should be fine.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
"NonProfit" <(E-Mail Removed)> wrote in message
news:BCD7BF8E-6234-4D59-BE37-(E-Mail Removed)...
> I have a tedious task which I believe can be simplified considerably, but
I'm not sure how to do it. Here is the dilemma:
>
> I have an Excel sheet with one column which lists the unique identifier
for about 2000 records in an Access database of over 85,000 records. I need
to somehow pull the records listed in the Excel sheet from one of the tables
in the Access database. Is there a way that I can link this sheet to the
table to pull only those records listed? There is no unifying query that I
could run to get these same results.
>
> I know that there is a way tod o this, but I don't know how. Otherwise, I
will have to open both files and scroll down the Access table copying and
pasting into the Excel sheet. This would be very dumb, but I don't know
what else to do! Any advice is appreciated.
Similar Threads
