Link Excel to Access
 

I have a database that has part numbers, location, and description.
There is thousands.

I want to have a speadsheet where I can type in 10 part numbers (A1 - A10)
I want column B and C to autofill with the data pulled from Acess.

Is this possible?

Link Excel to Access
 

You can click on Data in the menu and select IMPORT EXTERNAL DATA and then
NEW DATABASE QUERY. Select MS Access as your data source and click OK.
After locating the database file select the query or table to import and
select the fields to import, click NEXT and add an optional filter, then
click NEXT and state the sort order (optional). You can save your query and
then click FINISH. If the cell pointer is not at the location where you want
the import to begin, move the cell pointer and click FINISH or click the NEW
WORKSHEET option button and click FINISH. You can then click on DATA in the
menu and select IMPORT EXTERNAL DATA and set the data range properties to
update the table on open or every 60 mintues or whatever...

As long as the table you're importing doesn't exceed 65536 rows, this will
work.

--
Kevin Backmann


"Jerid B" wrote:

I have a database that has part numbers, location, and description.
There is thousands.

I want to have a speadsheet where I can type in 10 part numbers (A1 - A10)
I want column B and C to autofill with the data pulled from Acess.

Is this possible?

Link Excel to Access
 

This is going to show all the table records though isn't it?
I only want 10-15 at certain times.
So if cell A2 says 546 I want it to go into Access, find part number 546 and
return strictly the data assosiated with part number 546.

"Kevin B" wrote:

You can click on Data in the menu and select IMPORT EXTERNAL DATA and then
NEW DATABASE QUERY. Select MS Access as your data source and click OK.
After locating the database file select the query or table to import and
select the fields to import, click NEXT and add an optional filter, then
click NEXT and state the sort order (optional). You can save your query and
then click FINISH. If the cell pointer is not at the location where you want
the import to begin, move the cell pointer and click FINISH or click the NEW
WORKSHEET option button and click FINISH. You can then click on DATA in the
menu and select IMPORT EXTERNAL DATA and set the data range properties to
update the table on open or every 60 mintues or whatever...

As long as the table you're importing doesn't exceed 65536 rows, this will
work.

--
Kevin Backmann


"Jerid B" wrote:

I have a database that has part numbers, location, and description.
There is thousands.

I want to have a speadsheet where I can type in 10 part numbers (A1 - A10)
I want column B and C to autofill with the data pulled from Acess.

Is this possible?

Link Excel to Access
 

Once your Parts data table is incorporated into the workbook you can use
VLOOKUP to return the column values from the part you want. Assume that the
following table is named PARTS:

Col A Col B Col C
PartNum Name Price
111 Wonder Widget 2.33
112 Ceiling Wax 1.88
113 Slippers 15.99
114 Gumshoes 44.99

In the sheet where you type the part number, put a VLOOKUP function to the
column to the right:

=VLOOKUP(A1,PARTS,2)
=VLOOKUP(A1,PARTS,3)

The above lookup formulas would look up the partnumber you typed in A1,
searching the table named PARTS. The first VLOOKUP would locate the part
number in column A of the PARTS table and when it finds the part number it
captures the value in column 2 (the part name). The seconds VLOOKUP would
get the price.

So
--
Kevin Backmann


"Jerid B" wrote:

This is going to show all the table records though isn't it?
I only want 10-15 at certain times.
So if cell A2 says 546 I want it to go into Access, find part number 546 and
return strictly the data assosiated with part number 546.

"Kevin B" wrote:

You can click on Data in the menu and select IMPORT EXTERNAL DATA and then
NEW DATABASE QUERY. Select MS Access as your data source and click OK.
After locating the database file select the query or table to import and
select the fields to import, click NEXT and add an optional filter, then
click NEXT and state the sort order (optional). You can save your query and
then click FINISH. If the cell pointer is not at the location where you want
the import to begin, move the cell pointer and click FINISH or click the NEW
WORKSHEET option button and click FINISH. You can then click on DATA in the
menu and select IMPORT EXTERNAL DATA and set the data range properties to
update the table on open or every 60 mintues or whatever...

As long as the table you're importing doesn't exceed 65536 rows, this will
work.

--
Kevin Backmann


"Jerid B" wrote:

I have a database that has part numbers, location, and description.
There is thousands.

I want to have a speadsheet where I can type in 10 part numbers (A1 - A10)
I want column B and C to autofill with the data pulled from Acess.

Is this possible?