Count records in a file.

  • Thread starter Thread starter Peter Nunez
  • Start date Start date
P

Peter Nunez

I am importing a file into my database on a daily basis.
I would like to calculate the number of records in the
imported file so that I can append it to a running daily
count table. How can I count the records in this file
using ADO?
 
if you are importing to a table, and the table has no other records
select count(*) from YourTableName
if it does contain records already, perhaps a where clause will help
HS
 
Thank you.
-----Original Message-----
if you are importing to a table, and the table has no other records
select count(*) from YourTableName
if it does contain records already, perhaps a where clause will help
HS




.
Click to expand...
 
Back
Top