Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

exporting a form as an html document

Status
Not open for further replies.

ecintern

Programmer
Feb 23, 2001
7
CA
I have created a form in Microsoft Access 2000 and wish to make it accessible from my our website which is created using ColdFusion. I am not sure how to make it into a web document. Also, we want users to be able to browse the form, but not make any changes to the data in it. If anyone knows how to accomplish this feat, I would appreciate any advice they can give me.

Thanks
 
Import or link (read-only) HTML tables and lists
Open a database, or switch to the Database window for the open database.


To import HTML tables or lists, on the File menu, point to Get External Data, and then click Import.
To link HTML tables or lists, on the File menu, point to Get External Data, and then click Link Tables.

In the Import or Link dialog box, in the Files Of Type box, click HTML Documents (*.html;*.htm).


Click a shortcut on the Places Bar or click the arrow to the right of the Look In box.


Select the drive and folder where the HTML file you want to import or link is located, and then double-click the file name.


Follow the instructions for the Import HTML Wizard or the Link HTML Wizard. Click the Advanced button if you want to edit an import/export specification or specify different file and field formats.


If your HTML file contains more than one table or list, repeat steps 1 through 5 for each table or list you want to import or link.
Notes

By default, Microsoft Access converts an HTML hyperlink address to a Hyperlink data type column, but only if all values in a table column or list contain a hyperlink address defined by an <A HREF> HTML tag. You can change the data type when using the Import HTML Wizard or the Link HTML Wizard. For more information on hyperlink addresses, click .


Microsoft Access ignores GIF and JPEG images embedded in the HTML tables or lists.


A table embedded within a table cell in an HTML file is treated as a separate table when you import or link. A list embedded in a table cell is treated as the contents of a cell, and each item in the list is delimited with the carriage return/line feed characters.


For data that spans rows or columns in an HTML table, Microsoft Access 2000 duplicates the data in each cell, whereas Microsoft Excel 2000 stores the data in the first or upper-left cell, and then leaves other cells blank.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top