Recent content by Sergo

  1. S

    Import Excel Data into Access via VBA

    Let's say I have multiple files. Some of them are the same like your example and same header, but the rest excel files are missing few headers (fields), 1-2 shorter columns, but header names are same. So my question is, will your code work for the excel files with missing few header to import to...
  2. S

    Import complex text file into Access

    Looks like it needs spesial case just for Citation field.
  3. S

    Import complex text file into Access

    I see, there is no data below.
  4. S

    Import complex text file into Access

    I'm looking and I see Citation 1, Citation 2 and so on..
  5. S

    Import complex text file into Access

    One more question. Once its transfer to the spreadsheet, why is Citation filed is blank? Is it supposed to be like this so user can add?
  6. S

    Import complex text file into Access

    You right, i should try it. Thank you very much all for your help!
  7. S

    Import complex text file into Access

    WOW, works like a champ! I thought we go to plan B, but this way is way better. One think. I know I'm asking to much. Can you change it, so it's saves in database. I tried to change it, I'm getting lost. This way I'll make this table as temperately, so the user can make corrections to data and...
  8. S

    Import complex text file into Access

    The one Uncle Gizmo sent, it was easy to read, because it has comments. When I write a code I don’t put comments, I’m lazy on comments. :)
  9. S

    Import complex text file into Access

    But what I’m good with; I can read the code and follow it, and learn a lot from it.
  10. S

    Import complex text file into Access

    If that text file would have the record (citation) in each line and with delimiter, then this would be one line code, maybe few. But this complex text, I have no idea! :)
  11. S

    Import complex text file into Access

    I just confirmed with the user, it is an end of record line.
  12. S

    Import complex text file into Access

    About attempts. I haven’t done anything yet. All I have is Uncle Gizmo’ copy with some modification. I’m at work right now and this is my outside of work project to get experience in VBA. Like I was mention on the beginning that I helping co-worker to build this database for tracking citation...
  13. S

    Import complex text file into Access

    Looks like, it is end of record. Can we ignore them?
  14. S

    Import complex text file into Access

    We can remove (trim) line breaks. Does trim only removes spaces or line breaks too?
  15. S

    Import complex text file into Access

    Like I was mention earlier, no it does not have line#, but we can populate Line# with the code that Uncle Gizmo sent. So, are we still going plan A – initial plan. Or Plan B – transfer only 2 fields Citation# and Citation Data (Memo field)?
See more
Top Bottom