Viewing 5 posts - 1 through 5 (of 5 total)
Thank you Nick for respond. I will try it today and let you know the result.:-)
November 9, 2009 at 11:31 pm
That is exactly right. Thank you a lot for help. I will try it today.
I got the idea how it goes.
You really help me much.
Thanks
August 1, 2009 at 11:32 am
Thanks for reply.
When I run this:
DECLARE @cmd VARCHAR(4000)
DECLARE @currentdate VARCHAR(10)
select @currentdate = convert(varchar(8),getdate(),112)
SET @cmd = 'INSERT INTO OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',
...
July 21, 2008 at 10:01 am
bitbucket (7/20/2008)
DECLARE @cmd VARCHAR(4000)
DECLARE @currentdate VARCHAR(10)
select @currentdate = convert(varchar(8),getdate(),112)
SET @cmd = 'INSERT INTO OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',
...
July 20, 2008 at 11:51 pm
Thanks to everyone for reply. I will try all sugested options and let you know the result.
July 20, 2008 at 11:43 pm
Viewing 5 posts - 1 through 5 (of 5 total)