Results 1 to 4 of 4

Thread: Sql - tables and questions

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte Jlamarre's Avatar
    Join Date
    Nov 2018
    Posts
    22
    Articles
    0
    Excel Version
    2016

    Sql - tables and questions

    Hello all,

    I'm no Excel master obviously. I have a warehouse that some employees scan in a file items that I need to buy to replenish our shelves.

    We do have a inventory software but for some reason it can't do exactly what we need it to. So my items are removed from my inventory only when it is sold. Not picked. And I can use the min /max option. Hence the need for my excel file.

    In my file I have the part number and quantity on the shelf.

    I was given access to the SQL database (read only). So with that I can get all the information I need. Min/max, description, last perchanced price, supplier etc. (all of the info are gathered with vlookup)

    All that info comes from 3 different tables. In all its a little more then 500k lines.

    Is it possible to have Excel look in the tables with the connection without having a "copy" of what is in the tables in my excel document? Or do I need to have a separate excel document with all the tables. But what if an other user would like to "connect" to that file with all the info. I tried to have the file saved on my cloud. But that slowed down everything.

    Any ideas, suggestions?

    Thank you



    Sent from my SM-G955W using Tapatalk

  2. #2
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Location
    USA
    Posts
    52
    Articles
    0
    Excel Version
    2019
    Jlamarre,

    Are you using Data ,From other Sources, from SQL Server?

  3. #3
    Acolyte Jlamarre's Avatar
    Join Date
    Nov 2018
    Posts
    22
    Articles
    0
    Excel Version
    2016
    Quote Originally Posted by Heyjoe View Post
    Jlamarre,

    Are you using Data ,From other Sources, from SQL Server?
    Yes the data comes from MS SQL Server 2014.

    Thank you

    JL

    Sent from my SM-G955W using Tapatalk

  4. #4
    Acolyte Jlamarre's Avatar
    Join Date
    Nov 2018
    Posts
    22
    Articles
    0
    Excel Version
    2016
    Asked in an other thread in a different way. Might fill in some blanks.

    https://r.tapatalk.com/shareLink?url...5&share_type=t

    Sent from my SM-G955W using Tapatalk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •