exporting data from exel to a database..

Is there a way to export data in excel to MS SQL server, or Access?
thanksIn 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?

thanks