How Do I open an Excel spreadsheet within MS Access database.?

I have an application designed in MS Access.I have to open an Excel file within the Access.How do I do it

2 Answers

Relevance
  • 1 decade ago
    Best Answer

    Excel to Access

    Excellent link. A tad long. Will explain everything.

    http://office.microsoft.com/en-us/access/HP0109509...

    Import, export, and link data between Access and Excel

    You can share data between Access and Excel in many ways. You can copy data from an open worksheet and paste it into an Access datasheet, import a worksheet into an Access database, or simply load an Access datasheet into Excel using the Analyze it with Excel command. This topic explains in detail how to exchange data between Access and Excel by importing, exporting, or linking to data.

    ****************************************************************

    Excel to Access

    Excellent link. A tad long. Will explain everything.

    http://office.microsoft.com/en-us/access/HP0109509...

    Import, export, and link data between Access and Excel

    You can share data between Access and Excel in many ways. You can copy data from an open worksheet and paste it into an Access datasheet, import a worksheet into an Access database, or simply load an Access datasheet into Excel using the Analyze it with Excel command. This topic explains in detail how to exchange data between Access and Excel by importing, exporting, or linking to data.

    **********************************

    I tried this:

    open Access

    click in “blank Access database,” o.k.

    − give the file a name, cl o.k.

    − click create

    − click the “new” button on the toolbar

    − to create a “new sheet in datasheet view” click o.k.

    − click Import Table

    − Locate the Excel file and double-click it

    − specify which worksheet you want to import

    − (if your headers cannot be used for field name, Access will assign them − you can change later on

    − click “first row contains column headings”

    − click “next”

    − cl “in a new table”

    − cl “next”

    − you can name the fields, Next

    − Let Access assign a primary key

    − Next

    − “Import to Table ???” - name the Access Table

    − click Finish

    ******************************

    Got this information from the Help button in Access:

    Change a field name in Datasheet view

    1. Open the table in Datasheet view.

    2. Double-click the field selector of the field that you want to change.

    Note If the Caption property has been set for this field, the text displayed in the field selector may be different from the actual field name. In this case, when you double-click the field selector, the caption text will be cleared and replaced with the field name. If you continue, you'll be editing the field name, and when you press ENTER to save this change, the caption text will be deleted. If you don't want to delete the caption text, press ESC immediately after double-clicking the field selector to cancel editing. For more information on using the Caption property, click .

    3. Type the new field name, following Microsoft Access object-naming rules.

    4. Press ENTER to save the new name.

    Caution If you have expressions or Visual Basic for Applications code that contain references to a field whose name you are changing, you must update all of those references to the new name.

    ******************

    Change a field name in Design view

    1. Open the table in Design view.

    2. Double-click the field name you want to change.

    3. Type the new field name, following Microsoft Access object-naming rules.

    4. Click Save on the toolbar to save your changes.

    Caution If you have expressions, or Visual Basic for Applications code that contain references to a field whose name you are changing, you must update all of those references to the new name.

  • 4 years ago

    If it were a database, you can use a timed query at some regular interval, then if it returns with records you get an alarm (pop up probably). I don't know what languages you may know, but any could be used realy. For a spreadsheet, so long as the spreadsheet is open and you have a means of executing code (via timer or button) then you can do the same. Excel didn't have timers, so I wrote my own in C++ and can do the same in VB, just an external timer that triggers a macro in the spreadsheet. Even if you are not a VBexpert, you can just have a macro sort your appointments, so that your next reminders are at the top. But though I can do each of those, I can't help wondering if you can. So there is another oprion that is probably much better. Get a google account and use google applications. Added advantage of not being tied to your laptop, if it gets broken you can still get to all of your data. Documents, spreadsheets, calender, websites both private and public, Email which you can forward to your company email or vice versa, It is quick and easy, make a note somewhere safe (no, not on that scrap of paper, on a proper piece of paper) of your username and password, pop it into an envelope in a tin box or somewhere. Because it wont be long before you are in and out of the office so often that you will use the auto-login then a year or so later when you have dropped your laptop in the cannel on a bad hair day, you can use that paper in that envelope to remind you of your login details.

Still have questions? Get your answers by asking now.