Thanks for your help Jim, I had been using SQL Server 2000 before and now I have to also do it on SQL Server 2005. It was just slightly different...

Hi,

I'm now using SQL Server 2005 and i've followed your instructions which have been a great help. But i need to import excel files and also .csv files. Is there...

Hi Ramesh,

I've imported the file as a text file (as it's in .csv format) and created a DTS package again. It now seems to work a treat and imports the...

Hi,

I've imported the file as a text file (as it's in .csv format) and created a DTS package, and it now works a treat. Thank you Mayank and Warren for...

Hi Mengus,

Thanks for your help, my query now works a treat. I've modified it slightly to break the information down further. My end query I've used is listed below...

Many thanks...

Hi Wameng,

Sorry I didn't get back to you sooner but I've had a couple of days holiday from work. Thank you for your speedy reply and your solution works well....