Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import spec ? (Access97)

    I'm importing a html report into Access97. I was able to import all the fields I needed which are field1, field2 and field25. I saved this as an import specifaction. The problem I came across was that the next month the html doc changed the number of fields. I was able to import field1 and 2 which didn't change. But field 25 which was a total field was now field 26. So oviously is imported field 25 which is what the specifaction stated. My question is I only need the first second and last fields of this report. Is there any way to tell access this? Or is there another way to get this data into an access table? Thanks...

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Import spec ? (Access97)

    You could do this in VBA code.
    First import the HTML into a table so it has fields Field1, Field2,...FieldX.
    Next determine how many fields there are in the imported table.
    Then write a loop reading data from the imported table and outputting the data to the table you wish.
    Short of providing the actual code, I hope this gives you one idea anyway.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •