User Profile

Collapse

Profile Sidebar

Collapse
sdc248
sdc248
Last Activity: Oct 2 '06, 05:02 PM
Joined: Oct 2 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sdc248
    started a topic Could not find installable ISAM
    in SQL Server

    Could not find installable ISAM

    Hi:

    I got an error message when I am trying to have a stored procedure import a table from an excel file. It's a SQL Server 2005 and I have enable the Ad Hoc Distributed Queries option. The query I am testing is as below:

    SELECT * FROM OPENDATASOURCE( 'Microsoft.Jet. OLEDB.4.0',
    'Data Source=S:\myfil e.xls;Extended Properties=Exce l 11')...TEST$

    The error message:
    OLE DB provider "Microsoft.Jet. OLEDB.4.0"...
    See more | Go to post
    • sdc248
      replied to transaction log file is full
      in SQL Server
      What query did you use to backup the transaction log? The following should work.

      backup log <your database name> with truncate_only
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...