how to; transfer a data base from excel to access office 2003 stu

R

ricki racer

I recorded an assignment in Excel and I should have done it in Access. Does
anyone out there know how to transfer the whole thing to Access. I have till
the end of the day to accomplish this or my grade will bejepordized
tremendously.
PPlease HHelp!

ricki racer
 
J

John Nurick

Access's facilities for storing and processing data are fundamentally
different from Excel's, so for anything more than the simplest
worksheet, "transferring the whole thing" is a complicated business.

But it is usually easy to import data from Excel to Access by using the
latter's File|Get External Data|Import menu command. Just about
everything else will have to be re-created using Access's own tools, and
database concepts rather than spreadsheet ones.
 
Top