Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dshibaev

    unix .txt in access vba (CR LF)

    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
  2. dshibaev

    unix .txt in access vba (CR LF)

    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...
  3. dshibaev

    unix .txt in access vba (CR LF)

    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
  4. dshibaev

    unix .txt in access vba (CR LF)

    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...
  5. dshibaev

    unix .txt in access vba (CR LF)

    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...
  6. dshibaev

    processing txt files

    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...
  7. dshibaev

    processing txt files

    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...

Part and Inventory Search

Back
Top