Please do not cross-post. We monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=236102

That's why I stopped fighting that one .

Check my recent post count if you need a confirmation .

Not that one again???

Why do you think I don't hang out here anymore?!?!

HTH.

Script then out, then execute the script on the other database. You can also use the dts transfer objects wizard to do this.

Why not use sql server exclusively as the back end and use access only as the front end (research access data projets).

Why this hate for triggers?

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=235387&sub=1

Why would you want to swap the columns then???

Got it wrong too... this is is really opened for interpretation cause the server gets realllllly silent when it is stopped .

Do all the servers have access to that drive?

Do all the server have permission to write to that directory AND overwrite the file if needed?

You don't need the cursor to do the insert, check out this post. The last part of my first post would be the way to go (assuming you can't...

Looks like an excel sheet... why don't you normalize the data??