Viewing 2 posts - 1 through 3 (of 3 total)
this link should help you out.
it's a step by step process.
September 29, 2010 at 2:48 pm
#1229356
Instructions are on my blogs : [/url]
BTW I finally found it.
You don't even need a linked server, just use openrowset:
example :
update OPENROWSET('Microsoft.Ace.OLEDB.12.0',
'Excel 8.0;DATABASE=c:\book1.xls', 'Select *...
September 29, 2010 at 2:29 pm
#1229331