Using Excel instead of Access as a database

As Norm pointed out, Excel does do ADO just fine.
--
John Goodfellow
irtfnm
use john at goodfellowassoc dot com

 

I _thought_ you'd eventually show up.
I've decided to go with Excel and ADO, and since I've already got some code
to access MS Access using ADO, I just had to make a few adjustments and all
is working quite well.

--
I support two teams: The Red Sox and whoever beats the Yankees.

 

Yep, we have a winner - it's you Terry!

 

Keep in mind that leaving users to manipulate data in Excel leaves you wide
open to all sorts of user input errors.

I think that's what VBA was getting at. If your data is dependent on it's
structure, I would NEVER use Excel for it. It's much to easy for the
'average user' to bust a very well coded application by simply screwing with
the worksheet. If you're getting along with ADO, write your own app for
users access the data. You can do this with a stand alone VB exe, an
intranet web page, whatever. The code is virtually the same, no matter how
you write the interface.

Never understimate the ignorance of an end user.