Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2010
    Location
    Bangor, Maine, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm trying to import an html and mht file into an MS Access database that I created. Are there special considerations or tricks to consider to make this happen. I am uploading csv files into the same database without issues. The files both have merged cell headers above the data table. Should I have these removed before or during the Import procedure?

    Thanks
    Yuri

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    There are special "wizards" in Access for importing csv or similar delimited files into Access, as well as columnar files like Excel. However HTML and various derived file types don't lend themselves to being imported into Access tables as individual records, and there are no "wizards" for doing that. Note however that XML, which is structured, can be imported. The only option I can suggest for such files is to store them as objects within a table that has a field defined as such. The more common approach with such files is to simply store a path and filename for the file in a text field. Hope this helps.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •