4 separate databases, 80% in Excel spreadsheet format; 20%
in Access. Total records are approx. 40,000 with similar
but not always exact field names. GOAL WITH COMBINING IS
TO MERGE ALL INTO ONE DATABASE, ADD MORE SPECIFIC FIELDS
AND INCREASE REPORT/USE OPTIONS.

Would you or would you not suggest converting Excel into
the Access, why or why not and is the volume of entries a
consideration?

Would you or would you not suggest converting Access into
the Excel database. Why or why not, and again, is volume
and diversity of fields a major consideration?

THANKS FOR ANY ADVICE.

Bonnie

you need to ask this question on an excel or access newsgroup. I will say
though that you need to move over to access. Excel can be used as a sort of
database but really that is not what it is designed to use. Doing everything
in access will give you a better experience.


"Bonnie Raddatz" <bonnieraddatz@aol.com> wrote in message
news:042801c36cc4$ba9320a0$a101280a@phx.gbl...