best way to do an excluded list

G

GregB

i have a program that generates an excell sheet every week, I want to import
that into access and run a query against a list in the database that will
take out all of the excluded entries from the excell sheet that I imported
in. I then want to export it back into an ecel sheet.


Are there any tuturials or good ideas on how to accomplish this?
 
J

John W. Vinson

i have a program that generates an excell sheet every week, I want to import
that into access and run a query against a list in the database that will
take out all of the excluded entries from the excell sheet that I imported
in. I then want to export it back into an ecel sheet.


Are there any tuturials or good ideas on how to accomplish this?
Click to expand...

I'd suggest an "Unmatched Query Wizard" query for the export. It's probably
not necessary to actually delete the records from the table before you do the
export.

If you'll post some details of the table and indicate how you would identify
which records need to be excluded, someone can probably help write the query.

John W. Vinson [MVP]
 
Top