>>I need some "recent" data from a SQL database at the clients site. I would like to simply select from SQL into a "scratch" MDB container, copy it to a CD, and bring it to my office. As long as I have an access DSN to recieve it, can I "simply" SELECT SQL data into the MDB?
>
>You should be able to use DTS to move it over to the Access file.
>
>Since it sounds like you're at their site, you could also create a SQL DB, move the data with DTS, detach the new DB and make the copy. Then all you'd have to do is attach the DB at your office instead of DTSing it again.
Thanks!:-)
>
>Also, if it won't take long and they don't mind, you could detach their DB, copy it, and re-attach it.
I'm sure they'd apreciate me interupting service for a few minutes:-)
Happy holidats - and thanks!
Imagination is more important than knowledge