Updating database table from Excel?
 

Is it possible to update or insert data into a SQL Server database table
from Excel (through MSQuery)? I am using Office 97. If Office 97 does not
have this capability, does Office 2000? Thank you.

Updating database table from Excel?
 

You can use DTS to import data from Excel into SQL Server.

Thanks,

Jim

Jim Vita
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.