Sql - tables and questions

Jlamarre

New member
Joined
Nov 29, 2018
Messages
22
Reaction score
0
Points
0
Excel Version(s)
2016
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
 
Jlamarre,

Are you using Data ,From other Sources, from SQL Server?
 
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
 
Back
Top