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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top