Adding information from excel

[basic]

I have a current database query set up that captures information from my
shipping records (Date, Part, Pcs. Shipping#). I would like to add a column
which would contain a invoice # which comes from an excel spreadsheet I
create.
The tricky part is I need to use the Shipping # in access to key what value
to put in the invoice # column.

Access Query Example:

Date Part Amount Shipping# Invoice#
10/1/08 71-45 10.00 9595 ?


Excel File:

Date Shipping # Invoice #
10/1/08 9595 12345


I need it to look at shipping #9595 go to the excel file and find Shipping
#9595 and put the invoice number that correlates to it in the Invoice #
column of my query.

Is this possible?

 

[KARL DEWEY]

Go to Get External data and link the Excel spreadsheet. Substitute the
correct table/spreadsheet names and fields in this query --
SELECT Date, Part, Amount, [Shipping#], [Invoice#]
FROM YourTable LEFT JOIN YourExcel ON [YourTable].[Shipping#] =
[YourExcel].[Invoice#];

 

[basic]

Thanks Karl that was just what I was looking 4.

Go to Get External data and link the Excel spreadsheet. Substitute the
correct table/spreadsheet names and fields in this query --
SELECT Date, Part, Amount, [Shipping#], [Invoice#]
FROM YourTable LEFT JOIN YourExcel ON [YourTable].[Shipping#] =
[YourExcel].[Invoice#];


--
KARL DEWEY
Build a little - Test a little

I have a current database query set up that captures information from my
shipping records (Date, Part, Pcs. Shipping#). I would like to add a column
which would contain a invoice # which comes from an excel spreadsheet I
create.
The tricky part is I need to use the Shipping # in access to key what value
to put in the invoice # column.

Access Query Example:

Date Part Amount Shipping# Invoice#
10/1/08 71-45 10.00 9595 ?


Excel File:

Date Shipping # Invoice #
10/1/08 9595 12345


I need it to look at shipping #9595 go to the excel file and find Shipping
#9595 and put the invoice number that correlates to it in the Invoice #
column of my query.

Is this possible?