Updating database table from Excel?

  • Thread starter Thread starter hmmm...
  • Start date Start date
H

hmmm...

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.
 
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.
 
Back
Top