Because I have no idea how to do that - and the IT cost is far to expensive for the report I would get!
so I thought it might be easy ( and also an interesting excercise how to do it?)
Because I have no idea how to do that - and the IT cost is far to expensive for the report I would get!
so I thought it might be easy ( and also an interesting excercise how to do it?)
Hang on.
You've said you have an excel sheet that's pulling information from Microsoft Nav
If that is the case, you can use that same mechanism to link data into an access database, THEN develop the report looking the way you want.
I am not saying develop the report in Nav.
My point is that microsoft products talk to microsoft products
https://www.layer2solutions.com/supp...codbc-database
this is how you would connect to a navision database using ODBC connections.
I would suggest though you look at how your excel file is connecting because the connection is likely already defined, you just have to leverage that to get it into MS access.