存储过程传参，求助

[elysium1984]

建立一个存储过程，目的是从access数据库中导入sql数据库。
代码如下：
create proc zhao @a varchar(255)
as
begin

declare @TMP_COM_BASEARG varchar(255)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMP_COM_BASEARG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMP_COM_BASEARG]

Select * INTO TMP_COM_BASEARG FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0','Data Source="@a";User ID=;Password=')...COM_BASEARG

end



exec yinlian e:\BMS_STO(101000).mdb



其中，access数据库在地址及数据库名称是要传入的变量，但是在建立数据库的过程中就出现错误了
用拼接字符串的形式也不行
请问高手帮忙解答一下。分不多，望见谅。

[jinjazz]

Select * INTO TMP_COM_BASEARG FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0','Data Source="'+@a+'";User ID=;Password=')...COM_BASEARG

[elysium1984]

create proc zhao @a varchar(255)
as
begin

declare @TMP_COM_BASEARG varchar(255)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMP_COM_BASEARG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMP_COM_BASEARG]

Select * INTO TMP_COM_BASEARG FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0','Data Source="'+@a+'";User ID=;Password=')...COM_BASEARG

end
这样的话，显示，+号附近有错误！

[jinjazz]

create proc zhao @a varchar(255) 
as 
begin 
 
declare @TMP_COM_BASEARG varchar(255) 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMP_COM_BASEARG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
drop table [dbo].[TMP_COM_BASEARG] 
declare @drv varchar(8000)
set @drv='Select * INTO TMP_COM_BASEARG FROM OPENDATASOURCE (''Microsoft.Jet.OLEDB.4.0'',
''Data Source="'+@a+'";User ID=;Password='')...COM_BASEARG' 

 exec (@drv)

end 

[elysium1984]

谢谢