Wow, thanks you all, I definitely was not waiting for so many constructive, alternative answers.
I am quite accustomed to programming in matlab, so all this story with objects kind of scared me at first, but as I see now it's quite an efficient alternative.
Well thanks again.
I'll be around
here goes the final solution:
inFile = FreeFile
Open "C:\Documents and Settings\Shibaev\Desktop\AFS_DB\data\zafs_ascii_v1.txt" For Input As inFile
lngChars = LOF(inFile)
strImport = Input(lngChars, inFile)
strImport = Replace(strImport, vbLf, vbCrLf)
Close #inFile
outFile = FreeFile
Open...
yeah you are right, as at first I had all the databases created I did not notice any difference and thought that the code processed it correctly, but I was wrong. In a few minutes I shall post a workaround that I actually got to work
Excelent! I am becoming a fan of this forum and hope to be able to contribute sometime soon.
JBinQLD, in fact you are right I used the code you suggested in my last thread for it working quite nicely for what is required
PHV, your sollution worked exactly right, I just change the place where...
Hey guys,
Having some problem in processing plan ascii files in access generated by a unix system. The problem is that (ref: code below) when I try to parse one line at a time, it recognizes the whole file as 1 line.
I remeber that there is diference between how two systems format the endline...
Excellent!
With just a few minor corrections (took about 5 min) the code was up and running!
Here is the corrected version (of course all the credit goes to JbinQLD) that simply prints the results to the debug window
Sub ProcessReportFiles()
Dim inFile As Integer
Dim outFile As Integer
Dim...
hey guys,
Assume a complete novice here (well kind of) who is looking for an efficient way to process .txt files. Actually a few days ago I decided to port all my reports that query to external databases to access and work from there.
Currently stuck with quite a simples problem on importing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.