Search results

  1. S

    Import complex text file into Access

    So all fields will look like Citation Database Author Title Source Abstract Publication Type
  2. S

    Import complex text file into Access

    I just found that some Citation will have "Publication Type" in the end. But rest of is always same.
  3. S

    Import complex text file into Access

    Waiting for approval post!
  4. S

    Import complex text file into Access

    Sorry I could not find attachment option, so I paste it here. Text is confidential, so I replaced with "bla bla". Field names I bold it. This "Citation" can continue over 100 records. Thank you! Citation 1. Database Bla bla bla bla Author Bla bla bla bla Bla bla bla bla Bla bla bla bla Bla...
  5. S

    Import complex text file into Access

    That is correct. But text3 most of the time has more the 255 char (multiple lines in the text file). So the code would probably read form next line after fieldName3 till fieldName4.
  6. S

    Import complex text file into Access

    Thank you foe the reply. Because Field1, Field2, Field3, Field4 are field names. Text1, Text2, Text3, Text4, are data. So once it's uploaded to table it will look like Field1 Field2 Field3 Field4 Text1 Text2 Text3 Text4 Text1 Text2 Text3 Text4 Text1 Text2 Text3 Text4 Text1 Text2 Text3 Text4 And...
  7. S

    Import complex text file into Access

    Hi! I’m trying to help my coworker to create a database. They are receiving e-mail with some data that they want to transfer to access database to track. The one think they can do is copy past, copy paste… That is a lot of data to copy and paste. The date looks like this format Field1 Text1...
Back
Top Bottom