Link MS Access (.mdb) with Excel

[Mardley O.]

Q1. Is it possible to link Access database to Excel spreadsheet..or vise versa
Q2. Can I edit any linked Access database (.mdb) in Excel if Q1. is possible.

TIA

 

[Guest]

In Excel if you click on Data > Import External Data > Import Data
Then select +Connect to New Data Source
Then select Other/Advanced
Double click Microsoft Jet 4.0 OLD DB Provider and select the database you
wish to use and click OK. Continue through the options to import data into
Excel, which at the click of a button can be refreshed.

I don't know of a way you can write this back to Access other than to make
your changes then import the excel document back to Access into a new or
existing table but this will mess up all your field properties.
--
Adam Thwaites
Access Database Designer
adam.*spamless*[email protected]
Manchester, UK
(I have no access to other sites apart from microsoft.com so posting
external links is no use to me)