G
Guest
Hi All.
I have an Access 2002 database, with tables linked to a SQL 2000 Server via
ODBC driver. What is the best way to append data (create a new record) to a
SQL table using data from a local Access table? I've tried append queries,
pass-through queries, and considered creating an Access Project instead, but
I'm having difficulties. Without knowing any details, can anyone suggest the
best approach to this?
Thanks in advance.
steve.
I have an Access 2002 database, with tables linked to a SQL 2000 Server via
ODBC driver. What is the best way to append data (create a new record) to a
SQL table using data from a local Access table? I've tried append queries,
pass-through queries, and considered creating an Access Project instead, but
I'm having difficulties. Without knowing any details, can anyone suggest the
best approach to this?
Thanks in advance.
steve.