Delisted Free Agent
- Nov 8, 2005
I stopped reading at MS AccessI asked him that question a few years ago and here are his exact words:
"Database is SQL Server, and there’s an MS Access front end to run queries (bit easier to drag & drop, rather than writing them all out in SQL). Stats are copy/pasted into an Excel spreadsheet; I open a form in the MS Access database, click a button, and everything is updated about 20 minutes later."
I am in IT by profession and I know SQL but mostly from a mainframe perspective and the Access/Excel stuff is where I get off the bus.
But it sounds like he had designed an MS/Access form to import the data from Excel to Access. Given how complex I imagine it would be in terms of the data structures that might be involved, I wonder about that.