PC Review


Reply
Thread Tools Rate Thread

Count Number of Records and Number of Fields in CSV File

 
 
ExcelMonkey
Guest
Posts: n/a
 
      29th Nov 2007
I have a CSV File. I want to be able to - via VBA in Excel - count the
number of rows of data (i.e. records) and the number of Columns (i.e Fields).


Assuming you can create a count variable and loop through records. I am
using a "~" as a delimiter for my fields. Assuming I can use a count
function to count the number of ~ per record to get my # of columns. Unless
there is a better way to do this.

Any ideas?

Thanks

EM
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count number of records if .... mariaw Microsoft Excel Worksheet Functions 2 14th Feb 2007 09:14 AM
Count number of fields that contain zero's =?Utf-8?B?c29ub2Zyb3k=?= Microsoft Access Forms 12 23rd May 2006 08:46 PM
Count number of records in ListBox HearSay Microsoft Access Forms 2 1st May 2006 07:44 PM
Count the Number of Records RobVT Microsoft Access Forms 2 16th Nov 2005 06:10 PM
count number of records =?Utf-8?B?Sm9lX0FjY2Vzcw==?= Microsoft Access 0 13th Jan 2005 05:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:30 PM.