Are you asking how to read the data from an Access table? That would just be
a simple
"Select * From table" SQL command.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"durex" wrote in
message ...

I already have my ADO stuff taken care of and know how to update, write
and delete fields in an Access database from Excel VBA, but I cant for
the life of me figure out how to get the results of a query from excel
vba.. just looking to create a simple If then statement based on the
record count of a particular table. Im sure this is much easier than
what Im making it out to be....

Thanks!!


--
durex
------------------------------------------------------------------------
durex's Profile:
http://www.excelforum.com/member.php...o&userid=27857
View this thread: http://www.excelforum.com/showthread...hreadid=489259