Search results

  1. S

    Import complex text file into Access

    Thank you for pointing this out! I did look and found that some citation has “s” some not. That is another reason it will not work. I need talk to users, because before start this project I asked them all labels (fields) in citation are consistent and structure is same. They told me “Yes”
  2. S

    Import complex text file into Access

    I like your strategy! I wouldn’t event guess to go this direction. I just ran it with the real data, you right, it did find same words in text on some locations. Thank you anyway for your hard work! What if we make it easy. I just want give user at list one option, otherwise they can continue...
  3. S

    Import complex text file into Access

    I see, thank you! :)
  4. S

    Import complex text file into Access

    I will follow with them. But if it's to complicate, the users will understand and except it.
  5. S

    Import complex text file into Access

    No. But we can add a line # with the code that send me Uncle Gizmo.
  6. S

    Import complex text file into Access

    It does, if you transfer first into memo field, which is only except no more then 65,000 char.
  7. S

    Import complex text file into Access

    To answer #4 I think so! It will be always same structure except for the last field "Publication Type", sometimes it's missing
  8. S

    Import complex text file into Access

    The users asked for. But if it's easier w/o it, then let's do it w/o it.
  9. S

    Import complex text file into Access

    1. Do we have all the field names that could ever be present? These are all fields: Citation Database Author Title Source Abstract Language Publication Type 2. The maximum number of citations. I don't know, but probably no more 200. In my opinion I don't think it's matter. Loop will go through...
  10. S

    Import complex text file into Access

    that is correct!
  11. S

    Import complex text file into Access

    That is only one field, sometimes it does in Citation, sometimes not.
  12. S

    Import complex text file into Access

    I think so. I can even ask users upload 50 Citations in the text file a time, if the user received over 100 or 200.
  13. S

    Import complex text file into Access

    as you can see some Abstracts have multiple lines.
  14. S

    Import complex text file into Access

    Yes, sometime they receive 4,5 Citation, sometimes over 100 in one email
  15. S

    Import complex text file into Access

    I will have the database with all these fields. Citation Database Author Title Source Abstract Language Publication Type
  16. S

    Import complex text file into Access

    So I copy 4 Citation in text file and ran it in database you sent me. Here is my output. Note: After I got output I replace all confidential data with the line, just left field names and I did not change the structure. 1 Citation 1. 2 3 Database 4 ----------------------- 5 Author 6...
  17. S

    Import complex text file into Access

    here is my output by using that code 1 Citation 1. 2 3 Database 4 Bla bla bla bla 5 Author 6 Bla bla bla bla Bla bla bla bla Bla bla bla bla Bla bla bla bla 7 Title 8 Bla bla bla bla Bla bla bla bla Bla bla bla bla Bla bla bla bla Bla bla bla bla bla bla bla Bla bla bla bla Bla bla bla...
  18. S

    Import complex text file into Access

    Sorry I miss-typed a derectory where my text file located. It did work. Here is the output. 1 Citation 1. 2 3 Database 4 Bla bla bla bla 5 Author 6 Bla bla bla bla Bla bla bla bla Bla bla bla bla Bla bla bla bla 7 Title 8 Bla bla bla bla Bla bla bla bla Bla bla bla bla Bla bla bla bla...
  19. S

    Import complex text file into Access

    Database shows "Not Responding"
  20. S

    Import complex text file into Access

    Oops! I forgot "Language" field Citation Database Author Title Source Abstract Language Publication Type
Back
Top Bottom