We copy a lot of data from MS Excel sheets into SQLServer database tables using simple copy + paste over Microsoft SQL Server Management Studio. This procedure works fine if the id of the row to copy ...
We're in the process of developing a SQL Server reporting model that integrates with the new Excel 2010. Questions: Has anyone used the new Power Pivot addon? What's your experience been like with ...
End users in my company frequently use Microsoft Query (through Excel) to perform ad-hoc queries of selected SQL Server databases. As we move to SQL Server 2005 on the backend, we are discovering ...