I am using Visual Studio 2005 to connect to a database on a remote SQL2000 server. I need to copy a table in a database on my local machine up to the server. How can I do that?
Thank you,
Do you have enterprise manager or sql management studio?
If so do use the Import/Export wizard to copy the table from A to B.
|||no - I have Access 2007 and it is nothing like Access 2000 which made this act easy
|||
Part of my problem is that I am using Vista and it is giving me fits.
|||This is "long ago at school" kind of knowledge for me. But can't u connect the sql server to your access database and copy the data across from within access?
|||Finally got it - the adp setup in Access 2007 is completely different but you are correct it does work and actually quite well - now that I learned how to use it. The brain always stops with learning incomplete.
THank you
No comments:
Post a Comment