Results 1 to 5 of 5
  1. #1
    thinkman is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2015
    Posts
    3

    Exporting Data - but HTML got altered by MS Access

    hello everyone, I am new to this forum. I was wondering if someone can help me with a ms access question.

    I am trying to build a database to store product information and also the product page in HTML. I was able to do this in MS Access, however the export process would alter the code....(the field is in long text, and in Rich Text format)

    For example, this is the code I store in the table:

    <html>
    <head>
    <title></title>
    </head>
    <body>
    ........
    </body>
    </html>,

    however when I exported in Text File or XML File, < got replaced by &lt; and > got replaced by &gt;
    the code after export becomes:
    <div>&lt;html xmlns=&quot;&quot;&gt;</div>

    <div>&lt;head&gt;</div>

    <div> &lt;title&gt;&lt;/title&gt;</div>

    <div>&lt;/head&gt;</div>

    <div>&lt;body&gt;</div>

    ..................................


    <div> &lt;/tbody&gt;</div>

    <div>&lt;/table&gt;</div>

    <div>&lt;!--End Template FreeAuctionDesigns.com Copyright 2008 All Rights Reserved.--&gt;&lt;/body&gt;</div>



    <div>&lt;/html&gt;</div>

    Please advise, thank you all in advanced.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Rich text uses &lt and might change other stuff too. Use Plain Text vs. Rich Text. My resources indicate default for Memo is plain text. Make sure a control on a form or something is not changing things up.

  3. #3
    thinkman is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2015
    Posts
    3
    I changed to plain text for the field, however when I run a query to choose of the records, it still shows the <div> &lt....

  4. #4
    thinkman is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2015
    Posts
    3
    i figured it out, basically I also need to change the text type to plain text in the form where I entered the data.
    thanks everyone

  5. #5
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    Or you can use VB charater codes Chr(60) < . Not sure if you can use ACII codes as well (&_#_60_;") is <. Underscores used to prevent this page from replacing character code with the symbol. Your way is probably easier, but it's worth noting that you can use chr(39) and 34 for single and double quotes when concatenating strings, if it helps, so the vb set can be useful.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Problems exporting to HTML
    By broodmdh in forum Import/Export Data
    Replies: 1
    Last Post: 08-27-2013, 08:58 AM
  2. Replies: 10
    Last Post: 12-13-2012, 11:59 PM
  3. exporting data from access to excel
    By tariq nawaz in forum Access
    Replies: 3
    Last Post: 09-06-2012, 09:29 AM
  4. Exporting to HTML Trouble
    By starhawk85 in forum Import/Export Data
    Replies: 2
    Last Post: 05-03-2012, 06:06 PM
  5. Exporting a query to HTML
    By Remster in forum Access
    Replies: 8
    Last Post: 09-10-2010, 04:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums