Question How to import a html with tables and images with vba

herbertioz · Dec 5, 2010

I want to import a html file with tables and images into my database.
Then I want to copy some of the tables and images into a report. Do someone have some suggestions?

I can use docmd.transfertext maybe, but what about the images?

How can I structure the html file in the tables?

DCrake · Dec 5, 2010

As a general rule you do not import images into Acces table, you import the full path and file name to the image into a field in a table and use this as a reference when opening or viewing the image.

herbertioz · Dec 5, 2010

Yes, thats ok. But do you have some suggestions to do that?

DCrake said:
As a general rule you do not import images into Acces table, you import the full path and file name to the image into a field in a table and use this as a reference when opening or viewing the image.

DCrake · Dec 5, 2010

What version of Access are you using? and what does the html file look like?

herbertioz · Dec 5, 2010

I am using access 2007. An example html file under:

Code:

<HTML>
<img src="picture1.png" alt="Picture1">
<img src="picture2.png" alt="Picture2">
<table border=1>
<tbody>
<tr>
<th>Title</th>
<th>Director</th>
</tr>
<tr>
<td>Excalibur</td>
<td>Boorman</td>
</tr>
<tr>
<td>Star Wars</td>
<td>Lucas</td>
</tr>
</tbody>
</table>
</HTML>

DCrake said:
What version of Access are you using? and what does the html file look like?

DCrake · Dec 5, 2010

A 2007 has option to import html files, have you tried that option yet?

herbertioz · Dec 5, 2010

I know of the import, but I need to do this automatically with code.(VBA)

DCrake said:
A 2007 has option to import html files, have you tried that option yet?

DCrake · Dec 5, 2010

if you use the wizard to create the savedimport then save it as a spec, you can then use vba to run the savedimport spec

docmd.RunSavedImportExport "YourNamHere"

herbertioz · Dec 5, 2010

Ok, but is it possible with docmd.transfertext and code the whole thing? And what about the url to the image?

DCrake said:
if you use the wizard to create the savedimport then save it as a spec, you can then use vba to run the savedimport spec

docmd.RunSavedImportExport "YourNamHere"

DCrake · Dec 5, 2010

To do it the way you want you may have to go the long way round and read each line 1 at a time and parse out the data and structure. Is there a reason why you can't use the prefered method.

herbertioz · Dec 5, 2010

Ok, thanks for help! I think I have to do this the hard way, we will see.

DCrake said:
To do it the way you want you may have to go the long way round and read each line 1 at a time and parse out the data and structure. Is there a reason why you can't use the prefered method.

Question How to import a html with tables and images with vba

herbertioz

Registered User.

DCrake

Remembered

herbertioz

Registered User.

DCrake

Remembered

herbertioz

Registered User.

DCrake

Remembered

herbertioz

Registered User.

DCrake

Remembered

herbertioz

Registered User.

DCrake

Remembered

herbertioz

Registered User.

Similar threads

Users who are viewing this thread