On Mon, 10 Oct 2005 16:00:01 -0700, The New Admin Asst <The New Admin
I am setting up database in access. I have all of the information needed to
start program. If my excel database is being up dated regularly do I need to
link or simply import?
If you link, then your database will reflect changes to the
spreadsheet as they happen. If you Import, you'll get a snapshot view
of the spreadsheet as it existed at the moment you imported, and
future changes will not be reflected.
Either method is appropriate in some cases - that's why you're given
the option of either linking or importing.
Once everything is in how would I set my query to read for search instead of
forms and reports?
Ummm... not sure I understand. You can base a Form or Report on a
parameter Query, which will 'read for search' (if I'm understanding
you correctly); you can use a Form's Filter property to display a
subset of the records; or (though this usually won't be necessary) you
can create a Query based on the linked or imported table, to search
for a single record or a subset of the records. That's what Access is
*for* - storing, searching, sorting and displaying information!
John W. Vinson[MVP]
