can you not reexport the file with text qualifiers?

my auditing databases aren't all that big. i have one per server (for 4 servers) and they all send their data to one collection server. there's no special hardware; it's...

i've been using ddl triggers for some time; i've caught our vendors tampering with our dbs on more than one occasion.

in reading this discussion, i thought it'd be pertinent to post this here:

since you mentioned w2k3 and sql05 x64, when you copy a large file from a fast disk to...

just for fun, i tried this and it worked...

EXEC sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

EXEC sp_configure 'Ad Hoc Distributed Queries', 1;

GO

RECONFIGURE;

GO

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=\\statedc1\Finance\loading.xls', 'SELECT * FROM [Upload$]')

i finally found a machine here that generates the errors you're seeing, so i'm doing some research. in the meantime, wouldn't it be faster to just create an import task...

it replaces whatever was there with whatever's going to be there. basically, it destroys whatever was there to begin with. that pretty much ruins the data.

i was being more picky...

dumb question... is there a tab in the xl sheet called 'upload'?

also, have you enabled openrowset and opendatasource in the surface area configuration tool for that server?

any update statement will ALWAYS ruin the data.

if you're unsure what the results will be, copy the table into a holding table, run your update against the holding table, validate...

have you looked at db mirroring (i'm assuming you're running sql05+)? we looked at clustering here but decided against it because there's still a single point of failure: the sql...

does this work in a query window?

SELECT * FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Excel Driver (*.xls)};DBQ=\\statedc1\Finance\loading.xls', 'SELECT * FROM [Upload$]')

what happens when you do:

start

run

type "\\statedc1\Finance\loading.xls" without the quotes

hit enter

does it bring up the xl sheet?

not too sure about the parameters passed to OPENROWSET, but assuming they're valid, are you running the query logged in as a sql user or a windows user? i'd check...

there's got to be a better solution, but for starters, go into the page's properties and increase its height.

all this will do is move where the page break is... it...

do you have named pipes enabled on both the server and remote side? are you able to connect from another machine? have you typed in the server name correctly? are...