Is it possible to create a linked server from an Excel spreadsheet and give it a primary key? If so, how?
Thanks,
--Stan
This was for a Report Builder issue that I've resolved another way, but it's still an interesting question for other uses...
|||
No, Excel has no idea of Primary Keys, using Report Builder you probably would create a logical primary key to accomplish the creation of relationships.
Jens K. Suessmeyer
http://www.sqlserver2005.de
