Results 1 to 2 of 2
Thread: Import spec ? (Access97)
2002-11-08, 19:34 #1
- Join Date
- Jan 2001
- 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...
2002-11-08, 19:43 #2
- Join Date
- Dec 2001
- Melbourne, Australia
- 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>