Joanne,
I tried your suggestion and it worked rather well. That opens some new avenues for me. Thanks!!
Troy
I tried your suggestion and it worked rather well. That opens some new avenues for me. Thanks!!
Troy
----- Original Message -----
From: Joanne Yargeau
To: 'vantage@yahoogroups.com'
Sent: Wednesday, October 30, 2002 4:25 PM
Subject: RE: [Vantage] ODBC Query in Excel
Troy:
If you have an excel spreadsheet, you could link this file in Access and
link to the Part bin table and show the part with the on-hand qty and then
once the query is run you could send it back to excel. I don't use ODBC
with excel becuase I am usually doing a lot of queries tied together and I
don't think you can do that in Excel.
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, October 30, 2002 4:03 PM
To: Vantage
Subject: [Vantage] ODBC Query in Excel
Does anyone know how I might accomplish the following?
In Excel, lets say I have a list of 200 part numbers in Column A (too many
to filter in an ODBC Query if I am correct). How can I use ODBC to link
those 200 parts to the PartBin table to populate the OnHandQty for each
Part? I want the OhHandQty in Column B next to each part.
Troy Funte
Liberty Electronics
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1036011787404086?>
<http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
l/S=:HM/A=1267611/rand=967240321>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]