Exporting to SQL Server

Topic

New Reply

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

Reply | Quote

Replies

I think you have put this in the wrong forum – this is for spreadsheets not databases.

Reply | Quote

It’s been posted in the proper forum too, so I am closing this one. Discussion proceeds here: http://windowssecrets.com/forums/showthread//142232-Exporting-Access-Table-to-Sql-Server

Reply | Quote