Can I link my Excel Spreadsheet to my Access Database?

Question

I want it so when I put a record/entry into one of them, it will show up on the other. Is this possible>

Answer 1

The simplest way, especially if you are unfamiliar with VBA coding, is to import the data into Excel. Go to Data | Get External Data | New Database Query



A dialog will pop up which will prompt you for the database driver that you would use. Select the Access database driver and point to the location of your database. Once you click on your database, you will see all of the available tables and queries that can be imported into Excel. When changes are made in your Access database, all you have to do in the Excel spreadsheet is right-click and click on the red exclamation mark to update the query.

Answer 2

Yes. All Microsoft applications can pass data between them but it needs to be coded in macros in each application or VB itself can be used to transfer from one to the other.

Answer 3

From the get get admission to to Menu, confirm for checklist>Get outdoors Date>link tables. confirm for Excel from the checklist varieties. next choose your excel checklist. get get admission to to will preserve this suitable table fairly approximately fairly like a many situations taking place table. The earnings perfect it fairly is transformations made in the two application could be stored. For a one way connection: you are able to desire to apply an ODBC indoors the Excel sheet to hook up with the database. on the Excel menu, bypass to import outdoors information>New Database question confirm for MS get get admission to to Database from the menu. indoors the communicate container confirm on your database and table. Then choose the fields you choose. confirm for ok. as quickly as you choose to interchange the get get admission to to information, click on the table in Excel, then bypass to the Menu and choose date>refresh information. it fairly is one way fairly. From get get admission to to to excel. desire that helps.