Opening HTML Files

There are several ways to open a HTML file as a database in Database Tour:

1. Opening by specifying file name. Select ADO interface, then choose File option and then browse for the needed file.
2. Opening through connection string. Select ADO interface, then choose Connection string option and write a connection string. This way is very flexible and allows to specify additional parameters in the connection string and override standard Database Tour connection behavior. It is recommended for advanced users. Here are basic connection strings (more examples and details can be found in the Internet):

   Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties="HTML Import;DATABASE=C:\MyData\MyHTMLFile.html";

Notes

1. In a HTML file, the <table> structures are presented as database tables in Database Tour.
2. This database type is supported only in 32-bit version.
3. Microsoft Jet OLE DB provider must be installed.

Hints

• Each Database Tour edition has both 32-bit and 64-bit versions. You can install both and use them depending on what type of database you need to work with.

See also

• Examples of ADO Connection Strings