Yes, you can insert info from Excel into Access. Go to Access first and create a new database (name it). On the new database there will be an insert option to import info from an Excel spreadsheet. Depending upon what version of Office you have will determine how you do this. I have Office 2007 that explains the various options for importing the Excel information. For instance, you can import the Excel Spreadsheet and even have a link between your Access database and the Excel spreadsheet. When you make changes to your Excel information, it will be reflected in your Access database, etc. You do not have to link them, though. It is just one option. Hope this little bit of explanation helps. Give it a try--its fun, too.
|