Count records in a file.

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?
 
H

HSalim

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
 
P

Peter Nunez

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




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top