Importing excel sheet solely for lookup purposes- not storage/permanent import.

[lbaccess101]

Goal: I have an excel spreadsheet I want to copy into an access form/report and one of those fields matches an ID in my access databases. Once imported, I want this report to spit out the matching names to those IDs. I see posts on how to import data from excel, but I do not want to save any of the data from this excel spreadsheet into my database. I want to just temporarily "run it"/"use it" to generate a report of matching names. Any thoughts?

thanks!



LB

[aytee111]

Access doesn't care if a table is temporary or permanent, it is just a table. You could delete the table afterwards, altho this would bloat the database over time. Or you could link to the Excel file (not import it), again delete the link afterwards without it affecting much.

[lbaccess101]

thanks aytee, will do!