Hi there,
I feel there is a need for a definitive FAQ on how to read Excel spreadsheets from a Select statement. The two basic approaches are with OPENROWSET or with a linked server (which can be created either through script or EM).
If you care to look through thread183-271507 and thread183-267681 (both of these are looong), you will see that there are lots of pitfalls, problems, and issues (esp related to security)
It would be great if someone knowledgeable could create an FAQ that covers the many possible angles, so that the next person in this situation can just 'follow the steps', instead of having to re-invent the wheel.
If someone cares to tackle this, thanks in advance!!
bperry
I feel there is a need for a definitive FAQ on how to read Excel spreadsheets from a Select statement. The two basic approaches are with OPENROWSET or with a linked server (which can be created either through script or EM).
If you care to look through thread183-271507 and thread183-267681 (both of these are looong), you will see that there are lots of pitfalls, problems, and issues (esp related to security)
It would be great if someone knowledgeable could create an FAQ that covers the many possible angles, so that the next person in this situation can just 'follow the steps', instead of having to re-invent the wheel.
If someone cares to tackle this, thanks in advance!!
bperry