I have a bit of a problem with SELECT INTO from dbase 4 tables to SQL

The code I am using is:

select * from openrowset('MSDASQL', 'Driver={Microsoft dBASE Driver (* dbf)
}; DefaultDir=C:\temp; SourceType=DBF', 'Select * from EMAIL')

The error message I get is:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider did not give any
information about the error.

I have tried to apply this code for other data sources such as EXCEL and
using the correct driver but still no ANSWER. My guess is that it is an SQL
Server setting or something that I haven't installed. I am using Version 7.

Any help would be grand!!!