Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2003
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exporting to SQL Server

    Hi wonder if you can help me ?? I have created a table (Tbl_XRef) in Access 2003 which is created on a click button (it performs various functions between old tables and new to create the above table). Once it is completed I want to transfer it automatically across to SQL Server on the same click event (after having manually deleted the previous version of the table in SQL server).

    I do have an ODBC link called ODBC1 which goes to the SQL Server database - can anyone tell me how to do this using a DoCmd.???

    Thanks for your help.

    Blitzy

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I think you have put this in the wrong forum - this is for spreadsheets not databases.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    It's been posted in the proper forum too, so I am closing this one. Discussion proceeds here: http://windowssecrets.com/forums/sho...-to-Sql-Server

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •