Kiwiman
Registered User
- Local time
- Today, 09:32
- Joined
- Apr 27, 2008
- Messages
- 799
Hi
I am using Access 2003 and trying to add some data to a SQL Server 2005 table. I have linked this using an ODBC link, and can open the table and run select queries on the table.
When I try and Append records to it, the table does not show in the table name box.
Does anyone know how I can resolve this? I guess there is something on the SQL Server side I need to set.
Thanks for your help.
I am using Access 2003 and trying to add some data to a SQL Server 2005 table. I have linked this using an ODBC link, and can open the table and run select queries on the table.
When I try and Append records to it, the table does not show in the table name box.
Does anyone know how I can resolve this? I guess there is something on the SQL Server side I need to set.
Thanks for your help.