Importing Lists From Excel

[ChunkyChats]

Hi,

I'm trying to import a list of employee details from Excel into Access. I seem to have hit a bit of a problem. I've cleaned the data and spent time optimising. However I have a 'list' created by 'data Validation' of locations where people are based in excel. Unfortunately this does not import to Access. I've Removed the data validation from excel and now it transfers! BUT!

Unfortunately when I try and make this a multiple choice selection again in access through lookup wizard it deletes all the records.

For info I created a separate table of locations as these may change and linked lookup wizard to that table.

Any Help gratefully received

 

[Ranman256]

Attach the excel book as a table
build a query to append data from the xl table into your internal table.
(in it you can set criteria or filters)

 

[AndyMauro0]

I'm trying to import a list of employee details from Excel into Access. I seem to have hit a bit of a problem. I've cleaned the data and spent time optimising. However I have a 'list' created by 'data Validation' of locations where people are based in excel.