Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2002

    Question Unanswered: Importing HTML Tables using DTS

    I have successfully used DTS to convert the tables and associated data imbedded in web pages into SQL Server tables. However, I have been running into a an error on certain web site (more than one) when trying to create an HTML File Source (not during transformation, just when I select the file name in HTML File Source and Click OK) using DTS. I get the error message 'Microsoft Jet Database Engine, Error Description: Unspecified Error.' When I try importing these same pages into MSAccess, I get a similar error, with the error code (-5016). I have searched MSDN and MS Knowledgebase and can't find a reference to this anywhere. When I try to import these same pages using MSExcel, it works correctly. Any idea what is going on?

    For anyone that is interested, I have attached one of the HTM files that causes this problem. I changed the extension to .TXT so that I could attach it to this post.

    I'm running SQL Server 2002, version 8.00.534, Windows XP with latest SP, and Office XP with Latest SP.
    Attached Files Attached Files

Posting Permissions

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