link between excel and access

[arpitraval]

Hey friends,

I want to know that what is the procedure to link one table of access to the excel. I export that table from access and then i went to dataconnection tab and by giving that path of access i hit ok and after that If i try to update soemthing in access then It wont update in excel after refreshing the data.... So kindly help me out in this case....

 

[Kiwiman]

Howzit

In excel you can:

Data >> Import External Data >> New Database Query

• Choose Data Source >> MS Access Database*
• Select your database
• Select your table or query
• Select your fields
• Impose your criteria if required
• Finish
• Select the sheet and location to return the data

To refresh this with the latest that is in the database, Right Click anywhere in the data, and Refresh