Create a lookup list from data in Excel

[JMFW]

Hi

Is it possible to use data in an excel spreadsheet to create a lookup list in an access table.

Thanks

 

[Norie]

You could create a link to the spreadsheet though File>Get External Data>Link Tables...

You should then be able to use it as if it was an Access table.

Also the data in the spreadsheet would have to be consistent.

 

[ChrisUK]

Hi

You can creat a table in Access from the File/Get External Data/Link Table menu option - choose the Excel files type

You will now have a new table in your Access Database which you can use, if you change the contents of the chosen Excel rows the access table will change!

HTH

Chris