I have a tracking database.
The main field are  Requestor Name and how may Tapes.
The user has an excel spreadsheet with a list of tape numbers in one
column. He wants to make sure that the list matches the requestor name  on a
given date. How do I import the Excel data into a table in text format by
clicking a button that will get the information into a table and a combobox
on the form. Also I must be able to display tape information on a
report,probably in a memo field maybe,there could be up to 400 tapes involved.
The reason why I said text format or Access format is because Excel makes
the database very larger. Can this be done?