CREATE PROCEDURE spx_ImportFromExcel03
@SheetName varchar(20),
@FilePath varchar(100),
@HDR varchar(3),
@TableName varchar(50)
AS
BEGIN
DECLARE @SQL nvarchar(1000)
IF OBJECT_ID (@TableName,'U') IS NOT NULL
SET @SQL = 'INSERT INTO ' + @TableName + ' SELECT * FROM OPENDATASOURCE'
ELSE
SET @SQL = 'SELECT * INTO ' + @TableName + ' FROM OPENDATASOURCE'
END IF
SET @SQL = @SQL + '(''Microsoft.Jet.OLEDB.4.0'',''Data Source='
SET @SQL = @SQL + @FilePath + ';Extended Properties=''''Excel 8.0;HDR='
SET @SQL = @SQL + @HDR + ''''''')...['
SET @SQL = @SQL + @SheetName + ']'
EXEC sp_executesql @SQL
END
from above stored procedure in sqlserver 2005 i need this stored procedure in mysql can anyone convert this code .............
|
| Author: Deepika Haridas 06 Nov 2009 | Member Level: Diamond | Rating:  Points: 2 |
Hello,
I have converted your SQL procedure to Mysql
Check if it works at your end
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`spx_ImportFromExcel03` $$
CREATE PROCEDURE `test`.`spx_ImportFromExcel03`
(
SheetName varchar(20),
FilePath varchar(100),
HDR varchar(3),
TableName varchar(50)
)
BEGIN
DECLARE psql VARCHAR(1000);
IF OBJECT_ID (TableName,'U') IS NOT NULL THEN
SET psql = 'INSERT INTO ' + TableName + ' SELECT * FROM OPENDATASOURCE';
ELSE
SET psql = 'SELECT * INTO ' + TableName + ' FROM OPENDATASOURCE';
END IF;
SET psql = psql + '(''Microsoft.Jet.OLEDB.4.0'',''Data Source=';
SET psql = psql + FilePath + ';Extended Properties=''''Excel 8.0;HDR=';
SET psql = psql + HDR + ''''''')...[';
SET psql = psql + SheetName + ']';
/*EXEC sp_executesql psql;*/
END $$
DELIMITER ;
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|
| Author: HimaBindu Veeramachaneni 06 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Please check in mysql forums or website
http://dotnetspider.com/mentors/18-HimaBindu-Veeramachaneni.aspx?tab=details'
|
| Author: archana 06 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
above stored proc where it is stored..........
|
| Author: Deepika Haridas 06 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Hello archana,
You can store it at your own path.
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|
| Author: Nikhil Gaur 07 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
look at this lnk
http://www.dbforums.com/mysql/1627975-convert-sql-server-stored-procedure-into-mysql-stored-procedure.html
Join this campus group
http://www.dotnetspider.com/sites/637/-ecb-aspdotnet.aspx
Thanks & Regards
NIks
My Software and Web Development Experience
|