Kayleigh
Member
- Local time
- Today, 03:52
- Joined
- Sep 24, 2020
- Messages
- 706
Hi,
I am attempting to create a convertor tool in Access which will take values in a given spreadsheet, perform the conversion calculation and then export back to excel.
So far I have managed to perform the calculation effectively as well as export in a limited way. Basically I am just looking to brush up my tool so it can be used independently by other users.
Have attached system done so far. Here is more I would like it to achieve:
Good night and thanks
I am attempting to create a convertor tool in Access which will take values in a given spreadsheet, perform the conversion calculation and then export back to excel.
So far I have managed to perform the calculation effectively as well as export in a limited way. Basically I am just looking to brush up my tool so it can be used independently by other users.
Have attached system done so far. Here is more I would like it to achieve:
- Import excel files and immediately append to table in DB so calculation can work.
- At moment each class is queried separately so would like a user input to choose which class to query. Same idea for export.
- Also was trying to name sheet of exported spreadsheet but kept coming up with syntax error. Not sure why?
Good night and thanks