|
|
hi there..is there any one that can help ?..i got records in the database example : Areaid , Quarter, MeanScore.. now my task is to separate the quarter according to YEAR and Quarter (example 2003Q1) to different text file according to their year and quarter... how can i go about doing it or is there any website to learn about it..
|
|
|
|
|
It`s been awhile since your post, so if you are like me, you`ve probably found an answer by now. If you still need help, please email me at troy[at]troywolf.com. I`ve done this sort of thing a few times. Take heart! It is not difficult! You just need to get pointed in the right direction.
|
|
|
|
|
|
i had email u the help i needed...thxs a lot
|
|
|
|
Look Here
http://www.blueidea.com/bbs/archivecontent.asp?id=278961
You can also open a Text File using the "OLE DB Provider for Microsoft Jet"
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited;"";"
` Then open a recordset based on a select on the actual file
oRs.Open "/forum/Select__From_MyTextFile.txt", oConn, adOpenStatic, adLockReadOnly, adCmdText
|
|
|
|
|
|
|
|
|
|
|
// |
Archive Import (ger) 
Troy Wolf
