I have been trying to figure out the best way to move an excel spreadsheet that has reached its limits to a table on SQL. I tried using the import tool on SQL 2008 but any modification I make on the spreadsheet it reflect on the table. So I guess I am looking for a way to constantly insert data on the table using excel.
-
-
Excel have size limitations. So you will be restricted with that. Try upgrading your MS Office. The new version have a bigger limit. Or... create a GUI that you can use to populate your data. Or... edit the data directly in SSMS. Or...use a text file and import it in SQL Server as a table.
Good Luck!!!
~~ CK -
I think you can use SSIS to load data from excel to SQL server and perform delta loadingComment
Comment