Forum Discussion
ssklee
Apr 07, 2022Copper Contributor
It's been 15 years...
Hi All!
I have not worked in Access/Crystal Reports in 15 years and my mind doesn't seem to be having the magic moment where it all comes clear again...I have a very simple Excel spreadsheet for data linked to Access...I know what I need the report to look like but have completely forgotten how to set it up. I vaguely remember Groups and Subgroups and Queries...Are there people that I can send it to, get it set up and then I might get some sparks in my brain? For pay of course...I just don't have the gumption right now!
- George_HepworthSilver ContributorYour data is in Excel? Entirely in Excel? And you want to create a report in Access based on that data? Doable, but it does seem a bit limiting. How much time and money do you anticipate investing in this project? On the surface, it can't be very complicated (the data is in Excel), but these things tend to get more complicated pretty quickly. For starters, are you sure you even want to create an Access report using only Excel data? Wouldn't a tool like PowerBI be more appropriate?
- CARKIS51Copper ContributorTry importing (not linking) your excel data to an Access database. Use report wizards to create one. Use it as a starting point.