Linking Excel to an Access DB

[millzy7]

Hi,

I've found plenty of articles on importing Excel data into Access but I want my excel spreadsheet to connect and use data in an access db, ie read and write. Do you know of any good websites or articles that can help me?

Thanks

Millzy

 

[PHV]

To pull data the simplest way is a QueryTable (ie MS-Query)
For full I/O a common way is to play with a Recordset (either DAO or ADODB).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886