I have a list of part numbers in Excel, and would like to get other values(qty on hand, qty on order,cost) from the Mas200 database pertaining to those specific part numbers. I would like to "grab" the latest values from Mas200 and put them into Excel, if that makes sense. What would be the best way to do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data lookup from excel into Mas200
- Thread starter biobrian
- Start date
SkipVought
Programmer
Hi,
What kind of system is MAS200? Is it a database, file system???
Do you know where to get the data -- table name, file name?
Skip,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red][/red]![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
- Thread starter
- #3
Mas 200 is the company wide system we use for inventory management, accounting, etc. I currently use crystal reports and am able to access the database through crystal reports by opening a directory named ODBC, then a directory named sotamas90 where all the data tables are. I was able to get the info I need into a Query in Excel, but I am unsure on how to use the query and link it to the spreadsheet i want to create. I also need the info I am looking up to be the the most up to date(quantities, costing).
SkipVought
Programmer
Sounds like you already have an ODBC driver configured for the database.
On a new sheet...
Data/Get External Data/New Database Query --
and select your driver, then the table(s) you need and EDIT in the Query Editor.
When you have finished configuring the query, File/Return data to Excel
Skip,
[red][/red]- Status
Similar threads
