How Can Import Excel.

[CyndyG]

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?

 

[Ken Snell [MVP]]

Let's start with the import of EXCEL data. Use the TransferSpreadsheet
action in a macro or VBA text to import an EXCEL spreadsheet into a table.