How to Convert an Access Database to a Web Page

Save

You can use several approaches to convert data in Access to a web page. One of them is to use Access' export function, which results in a read-only web page. Another is to use an online service to convert the data, which results in an interactive page that others can use to modify your data.

Things You'll Need

  • Internet access
  • Microsoft Access

Export in Access

  • Open any existing database in Access. In the navigation window, choose a table for conversion to HTML, then click that table's icon. If you want to export only a subset of the complete table, double-click the table's icon to open the table, then select the rows you want to export.

  • Select "External Data" on Access' toolbar, then click the "HTML Document" icon in the "Export" group of tools.

  • Select your preferred export options in the Export-to-HTML wizard. Click "Browse" to select the HTML page you want to export to. Check the check box labeled "Export data with formatting and layout" if your table has borders, bold or highlighted text you want to preserve.

    Check the "Open the destination file" check box to inspect the resulting HTML page when the wizard completes.

  • Click the check box "Export only the selected records" to convert just the table rows you selected from step 1. In the "HTML output options" dialog box, select the "Select a HTML Template" option if you previously made a web page to provide a GUI (Graphical User Interface) for the table. Select that page using the "Browse" button, then press "OK" to complete the wizard.

  • Inspect the resulting HTML page. If the formatting doesn't fully meet your needs, edit the file in a Web page editor (e.g., Visual Web Developer, Dreamweaver, or Notepad).

Convert with an Online Service

  • Open up docs.google.com in your browser to create an interactive, readable and writable web page from your database.

  • Press the "Create new" button on the screen's left side and then select "Spreadsheet."

  • Return to Access and double-click the navigation window's icon for the table you want to convert to an HTML page. Select the rows and columns you want to copy, then press Control-C to copy them to the clipboard.

  • Activate the new spreadsheet page you made in step 2. Click anywhere on that page and press Control-V to paste the Access table data onto the sheet. Save the sheet by pressing "Save" (in the window's upper-right corner) and typing name for the sheet when prompted.

  • Format the data using the toolbar in the spreadsheet's window. Apply font styles, highlights, and background colors as needed. Press the button with the summation symbol (which looks like an "S") to apply formulas, such as "sum," "average," and many statistical, engineering and other functions.

  • Press the "Share" button (upper screen right), then "Publish as web page" to begin creating the web page from the spreadsheet. Select the sheets you want to publish, then click "Web page" under the heading "Get a link to the published data." Select and copy the link to the page, then paste that link in a new browser window to inspect the page.

References

  • Photo Credit Christopher Robbins/Photodisc/Getty Images
Promoted By Zergnet

Comments

Resources

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!