Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  Link or import the tables from Excel to SQL

Author  Topic  joy_hw Starting Member 8 Posts Posted - 2011-05-26 : 20:25:06 I'm trying to find out a way to link an excel file instead of importing the tables from the excel so that everytime I update the data in the excel file, without going through dropping the table or deleting the data and re-importing the table back to SQL, I can still get the updated information. I was told the reporting service might offer an option, but I'm not familar with it at all. Any help would be appreciated.