Count records in text file

G

George

I would like to count the number of records in a text
file through VBA in Access. The file consists of
variable length records. Currently I read one line at a
time and increment a counter until the end of file is
reached. Is there a better, faster way?

Thanks
 
M

May

can you show me your code so that i can have a better idea

May
MCP in Access and SQL Server
 

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

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Need VBA Macro to Loop through pages and print counter in footer of each page 9
Copy previous record into form field 0
Improving Macro That Keeps First Letter 0
New computer, how do i move outlook 365 ENTIRELY? 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Grow/Shrink Text gradually from slide to slide 0
Finding the proper style field and the numbered paragraph value within the style 0

Top