Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default counting data from an Access database

I've successfully been able to retreive Access data and bring it into excel
with the help of postings from this website. I wanted to see if someone
could provide some code or insights that could help me count specific access
records, instead of retreiving them. Is this possible?

any help would be appreciated
--
Regards,

timmulla
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default counting data from an Access database

Something like:

select count(t.*) from tablename t
select count(t.*) from tablename t where t.fieldname = "whatever"

--
Tim Williams
Palo Alto, CA


"timmulla" wrote in message ...
I've successfully been able to retreive Access data and bring it into excel
with the help of postings from this website. I wanted to see if someone
could provide some code or insights that could help me count specific access
records, instead of retreiving them. Is this possible?

any help would be appreciated
--
Regards,

timmulla



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Get Data from a secured Access database erick-flores Excel Discussion (Misc queries) 2 November 16th 06 05:31 PM
How to import data from Access Database. vidi[_2_] Excel Programming 2 July 20th 06 07:29 PM
Storing Data in Access Database... Ernst Guckel[_4_] Excel Programming 5 April 9th 05 11:46 AM
excel to get data from an access database confused Excel Discussion (Misc queries) 1 February 18th 05 06:29 PM
Filtering data out of access database Kashgarinn[_4_] Excel Programming 3 August 23rd 04 01:13 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"