Am I looking to do this backwards?

[ArcherSteve]

I have an Access Database setup that sorts archery scores. I want to export a query to a specific sheet in an Excel file that is setup for playoff bracketing which has formulas that automatically advances the winner of a match to the next round.

Now my question is, am I looking at this backwards? Would it be easier to import the excel file into access? Or should I stick to exporting data to excel? I want this to be automated as much as possible to the user has to do as little as possible (ideally, hit a button and the bracketing pops up...)

If anyone has any ideas (or possibly some VBA code.... ) please let me know.

Thanks
Steve

 

[statsman]

Do a search for "tournament". A while back we had several people looking for help in a number of sports. Some of their threads may be of assistance.

 

[allan57]

Try the following link

http://www.access-programmers.co.uk/forums/showthread.php?t=83534

 

[ArcherSteve]

Thank you both for responding. I'll look into both.