ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Parts List with Manufacturer
http://www.istechforum.com/YaBB.pl?num=1094576670

Message started by NTI STL on 09/07/04 at 09:04:30

Title: Parts List with Manufacturer
Post by NTI STL on 09/07/04 at 09:04:30

We would like to get a report with the following info:
Our part number
Description-both lines
Manufacturer Name and Number

Is this Possible without a special report or a great deal of editing in a program like Excel?

Title: Re: Parts List with Manufacturer
Post by aricon on 09/07/04 at 09:58:53

I would set up an ODBC connection an use the Query Manager in Excel to go and get that data. Then you can save that excel file and whenever you open it, it will ask if you want the data refreshed.

Title: Re: Parts List with Manufacturer
Post by troesch on 02/15/07 at 09:19:01

could you explain how to set this up?

Title: Re: Parts List with Manufacturer
Post by David Waldmann on 02/15/07 at 13:30:02

try http://www.istechforum.com/cgi-bin/YaBB.pl?board=ODBC;action=display;num=1163083349;start=4#4 to start. I don't know how to use Excel to get the data.

Title: Re: Parts List with Manufacturer
Post by JNAPIER on 02/15/07 at 15:26:28

Once you have your ODBC connection working, in Excell go to DATA, GET EXTERNAL DATA, NEW DATABASE CONNECTION. I think the table you need is MTICMSTR. After you build the query, save it for use later.

John