Access to Excel
I am creating a Excel packing slip that needs to pull information from an Access table. Is there anyway to do this without pulling the whole table from Access to Excel every time you want to ship something? So basically is there any way to search an Access table as you would in a VLOOKUP within Excel? -- tiab86 ------------------------------------------------------------------------ tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628 View this thread: http://www.excelforum.com/showthread...hreadid=530947 |
Access to Excel
hi tiab86
You can use the SQL string to retrieve the data you want http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl "tiab86" wrote in message ... I am creating a Excel packing slip that needs to pull information from an Access table. Is there anyway to do this without pulling the whole table from Access to Excel every time you want to ship something? So basically is there any way to search an Access table as you would in a VLOOKUP within Excel? -- tiab86 ------------------------------------------------------------------------ tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628 View this thread: http://www.excelforum.com/showthread...hreadid=530947 |
Access to Excel
Also some help explaining how to use the MS Query tool he
http://www.nickhodge.co.uk/gui/datam...taexamples.htm "tiab86" wrote: I am creating a Excel packing slip that needs to pull information from an Access table. Is there anyway to do this without pulling the whole table from Access to Excel every time you want to ship something? So basically is there any way to search an Access table as you would in a VLOOKUP within Excel? -- tiab86 ------------------------------------------------------------------------ tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628 View this thread: http://www.excelforum.com/showthread...hreadid=530947 |
All times are GMT +1. The time now is 01:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com