Search results

  1. M

    Import and Transpose From File Text File Into Table

    oooohhhhhh..... :D :D :D spectacular...from this code I can modify many source file text similar like this and convert it into table...thousand thank to you master.... access VBA is getting interesting to learn
  2. M

    Import and Transpose From File Text File Into Table

    if I use code below: If Left(strListItems, 1) = "1" Then cn.Execute "INSERT INTO BufferYBT(ref,lt) VALUES('" & Left(strListItems, 13) & "','" & Mid(strListItems, 15, 3) & "')" End If the result is only the content inside table text but the branch code, branch name, etcetera on top of table...
  3. M

    Import and Transpose From File Text File Into Table

    hi...iam beginner need help.. I want to insert (retrieve) text file and transpose into table Example: BANK "A" G501 Z000 TIME: 7:53:36 DATE: 24-07-2020 PAGE:0001 OVERDUE...
  4. M

    Solved retrieve text file content into listbox but not retrieve after comma

    hi...iam beginner need help.. I want to insert (retrieve) text file which is consist of multiple line into list box Example: 1170302000386 X18 COBA 1 20,000,000 41 1,000,000 258,333 1,258,333 19,000,000 60 1170302000399 X18 COBA 2...
Top Bottom