best way to do an excluded list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel Table Hyperlink to Acces 2003 3
Exclude most recent month 3
Run a Query that Excludes Values in A Table 4
best way to update table 2
Exclude additional duplicate account numbers 2
Transferspreadsheet - insert rows with no header 1
Average Function but exclude info 4
Excluding results in a Query 9

Back
Top