Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    Tradesman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    52

    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?)

  2. #17
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    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.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 04-30-2015, 02:09 PM
  2. Replies: 6
    Last Post: 02-28-2015, 11:57 AM
  3. Replies: 2
    Last Post: 08-14-2014, 11:49 AM
  4. Replies: 4
    Last Post: 04-26-2013, 08:32 AM
  5. Replies: 3
    Last Post: 02-26-2013, 05:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums