Chris,

Here is the query and the error.

Thanks.

Quinn

select sum(acres), case

when curage <= 5 then 'Age 0-5'

when curage >= 5 and curage <= 10 then 'Age 6-10'

when curage >= 11 and...

There are 29 columns in the defined area of the spreadsheet.

When I do a select on the name on the worksheet '6322missing$' I get all of the columns

exec sp_tables_ex'exceltest'

NULLNULL'6322missing$'TABLENULL

NULLNULL'6322missing$'Print_TitlesTABLENULL

NULLNULLDatabaseTABLENULL

NULLNULLTestTABLENULL

Here...

Glen,

I am up for whatever works best. If MS doesn't recommend it then I won't do it.

Thanks for your help and patience.

Quinn

Glen,

I have some good news. I created the linked server with the command that you sent me. Here is the result of exec sp_tables_ex'EXCEL':

NULLNULL'6322missing$'TABLENULL

NULLNULL'6322missing$'Print_TitlesTABLENULL

NULLNULLDatabaseTABLENULL

When I do a:

Select * from EXCEL...['6322missing$']

and

Select...

Glenn,

At the bottom of the excel spreadsheet it says 6322missing and not sheet1.

I appreciate all of the help.

Quinn

There wasn't any error for the first one and here is the error for the second commands.

Msg 7314, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked...

Glen

I had the file on a second server and then moved it to my PC which is the C:\. After your post I was thinking maybe the SQL server didn't...

Glen,

I have tried it on another server and on my hard drive on my desktop but not on the server that SQLServer is on.

Does it nead to be there?

Thanks

Quinn

Glen

I have already changed it to 8.0 instead of 5.0.

I have tried using a linked server and got the same error. I have 50 excel spreadsheets that need to...

Jeff

I am assuming that sqlserver have access to c:\temp sence the account that SQL is running on is administrator and adminitrator have full access.

Thanks.

Quinn

Thanks for the help.

I enabled ad-hoc queries from surface area configuration. Nobody is in the excel ss.

As far as server permissions to c:\temp do you mean the SQL Server of...

Thanks for the link.

There was nothing there that seemed to stand out as being a problem with my connection. The version of msexcl40.dll is the same on both machines.

I...

Paul

That is interesting information. Thanks for the link.

Quinn

Thanks Paul

Here is the output from that:

Msg 8906, Level 16, State 1, Line 1

Page (1:599) in database ID 4 is allocated in the SGAM (1:3) and PFS (1:1), but was...

David,

Here is the error I am getting right out of the log file:

2008-08-15 04:00:02.45 spid55 SQL Server detected a logical consistency-based I/O error: incorrect checksum...