Hello,
I need to import a bunch of .csv files. The problem I am having is the
"non data" information in the files creating bogus rows and column
definitions. Here is an example of the csv file.
CBOT - End-of-Day Futures Bulk Download 2001.
2 Year U.S. Treasury Notes Futures
Date Symbol Month Code Year Code Open
20010103 ZT H 2001 102.09375
20010104 ZT H 2001 102.03125
20010105 ZT H 2001 102.28125
In this case, there are bogues rows created with the text at the
beginning of the file, and also the column names get placed into a row
as well. My question is; how do you import the file and strip out the
"non-data" data? so that only the actual data gets inserted into the db?
Thanks,
TGru
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!