Finally,I could figureout this problem

EXEC sp_addlinkedserver

@server = 'QFODBCSRV',

@srvproduct = '',

@provider = 'MSDASQL.1',

@datasrc = 'QFODBC'

GO

Replaced provider 'MSDASQL' with 'MSDASQL.1'.

I have no logical answer why this worked.Even...

The other DB which I am trying to link is not another SQL Server.Its not so popular 'QuickFill' DB.Its driver is not present in the provider list of the LinkedServer.

Thanks for your reply Jack.

I posted 'SELECT TOP 10 ...' as just an example.It is happening for all the queries.

This is how I added new LinkedServer through my MSSMS

EXEC...

What is VBA?

After little bit of 'googling',I could successfully connect to my ODBC

1.)Exec sp_addlinkedserver

EXEC sp_addlinkedserver

@server = 'MY_ODBC_SERVER',

@srvproduct = '',

@provider = 'MSDASQL',

@datasrc = 'QFTest' //System DSN

GO

2.)To check...

Sorry Jeff. 🙂

Thanks John

Thanks for the quick replies.I am struck at this point.

I am running this command.It works perfect on the windows command line

bcp "select CUSTOMER_ID,Email1 from R4W_001.dbo.SYSCUST_AUDIT where Email1='abc@sarasu.com'" queryout "C:\SoundPub\EmailList\durga2.csv" -T...

Appreciate all yours Inputs so far.I could successfully create .xls files on Date basis now.But the problem I am having currently is,I have to convert these .xls files into .csv...

My Bad.

The mistake what did was,I did not give 'exec' before the SP.

Declare @filename1 varchar(40)

Declare @filename2 varchar(255)

Declare @filedate varchar(40)

Declare @copyfile varchar(255)

set @filename1 = 'C:\SoundPub\Batch\durga.xls'

set @filedate = 'Date' + convert(varchar,getdate(),112)

set @filename2...

After a little reading,I found out xp_commandshell would accomplish my task.Thanks for all your Inputs.But I am struck up at this point

Declare @filename varchar(40)

DECLARE @cmd VARCHAR(255)

set @filename = 'Date'...

Thanks for the replies.

Faheem latif & VijayKrishna I am still not sure how BCP is going to dynamically generate excel files (On the Date basis).

Jeff,I am still trying to...