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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ricki racer - 30 Jul 2006 14:34 GMT

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

Reply to this Message

John Nurick - 30 Jul 2006 16:25 GMT

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.

>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
[quoted text clipped - 3 lines]
>
> ricki racer

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message