User Sql Server Compact 3.5 as a data source in Excel 2007/2010?

User Sql Server Compact 3.5 as a data source in Excel 2007/2010? I'd like to provide users the ability to connect to a Sql Server Compact SDL from Excel to do some analyses. I'm having a hard time figuring out how to do this and would like a little help.
Asked by: Guest \| Views: 366

Total answers/comments: 1

Comments display order:

Guest [Entry]

Your best option will be a macro - see this sample: http://erikej.blogspot.com/2008/04/import-sql-compact-data-to-excel.html