can't get rid of duplicates

So do you import this data often? You could use the

DoCmd.Transferspreadsheet Method

Just look it up in Access help and it'll give you all the spcs. Hopefully this Excel spreadsheet is standard throughout and never changes.If it is only certain data you can create a query to only import certain data.

Here's the modules for the reports in reports zip. Sorry I should have commented better but who has the time. I included a readme.
 

Attachments

Thanks so many millions for all of your help. I think that it will benefit me to utilize the info for importing that you have given me b/c I will be needing to update this DB with the additional months that I will be receiving over a period of extended time for upcoming quarters and this should save me a lot of work.
 

Users who are viewing this thread

Back
Top Bottom