Results 1 to 2 of 2

Thread: record number ?

  1. #1
    Join Date
    Sep 2004
    Location
    Dallas, TX
    Posts
    77

    Unanswered: record number ?

    If I use access to open an excel worksheet. And put data from one query into the excel, how do I know how many records in excel? How many rows does excel has?

    Thanks a lot for any input

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    To Count the records

    SELECT COUNT(*) FROM ExcelName

    Where ExcelName is the Access name for the Link to Excel,

    Excel Has 2^16 = 65536 Rows

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •