Putting an Excel Lookup SS into a DB

[Guest]

Hi,

I have a Spreadsheet that has a range of values and one big lookup field
based on a formaula. I'm building a database and one of the fields to
calculate an employee's salary needs to come from this spreadsheet.

Is there a common method for putting this kind of information into an Access
DB?

 

[John Vinson]

Hi,

I have a Spreadsheet that has a range of values and one big lookup field
based on a formaula. I'm building a database and one of the fields to
calculate an employee's salary needs to come from this spreadsheet.

Is there a common method for putting this kind of information into an Access
DB?

Simply import (or link, if the spreadsheet will be updated
independently of Access) the spreadsheet into a Table, and base a
query on the table joining it to the employee table. The lookup field
becomes extraneous - that's one of the things that's a chore to do in
Excel which becomes a snap in Access.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps