Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
--we pass a parameter that tells where the Excel file is "@filepath" declare @DataSource varchar(600) set @DataSource = 'Excel 8.0;HDR=NO;Database='+ @FilePath + ';' exec (' insert into OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''' + @DataSource + ''', ''SELECT * FROM [Sheet1$A4:L4]'') select * from dbo.temp_Table ')
|MS SQL Inner Join - Multiple Join Parameters||2||21|
|MSSQL: Replace text (typo)||7||33|
|Whats wrong in the below query? Any help would be appreciated...||2||15|
|Using SQL Server 2008, why do I get the following error 'Explicit value must be specified for identity column in table 'tbl_CSL_CSLRpts' either when IDENTITY_INSERT is set to ON or when ?||8||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!