Ritesh what is it that is not working, can you let me know.

Good Article. Every one should go through this.

Thanks Vandy, one of my colleague found how to do it, the following is the code.

Function Main()

dim dtNow, TimeNow

dtNow = Date

dtNow = replace(dtNow,"/", "-")

TimeNow = Time

TimeNow...

Hey Vandy, Thanks for the help.

Can u tell me what is it that i have to do after i get the file name.

I really am confused on how am i...

Hi Doug Perlich,

What you could do is use the Global Temp Table.

Open Query Analyzer and create a Global Temp table (##TempTable)

The use the DTS (Import & Export) to load data...

Thanks Kaddie Abdul, It worked through DTS, Thanks. I first created the Temp table in query analyser and then used the DTS to populate the data into that Temp table....