In Enterprise Manager, Data Transformation Services, Local Packages, right click, create new package. On the left side of the screen is an EXCEL icon. You can use that to read from a spread sheet and insert into a table. You can then schedule the package to run or run it manually as needed.
Originally posted by ab8140
Is there a way to export data in excel to MS SQL server, or Access???