View Single Post
  #2 (permalink)  
Old July 16th, 2007, 07:03 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Can you post a couple lines from the text file? This will help in knowing how to capture the data. Then post what the table will look like that you want to store the data in, WITH some sample data. For example, if your file is:

SampleTextFile001.txt
- line of code
- line of code
- //comment line
- line of code

And your table is:

tblCodeFile
CodeFileID - autonumber PK
FileNameAndPath - text
LinesOfCode - number

And your sample data is:

tblCodeFile
1
C:\SampleData\SampleTextFile001.txt
3


then it will be easier to write knowing this structure and outcome.

To get started, you will want to use Scripting.FileSystemObject, which is documented on MSDN.



mmcdonal
Reply With Quote