I regularly move data in both directions.

Excel into SQL Server - I firstly name the range of data I want to import including the headers [as I have other rows...

Try http://www.hammerman.com/ - there is some useful stuff there too.

I have had this problem and someone helped me out with a fiddly (and odd) but working 'solution'.

You select all of the data in the Excel column. Copy and...

I don’t have a solution, but have done a fair bit of searching on 7399 and 7370 errors for linked servers. You could check out an old web-cast on...

Thanks for the response. The linked servers are actually named ranges in Excel files. They are only set up for me, and my login is the only one...

In DTS you could do an ActiveX transformation of the problem columns along the lines of:

'**********************************************************************

' Visual Basic Transformation Script

' Copy each source column to the

' destination...