Import to SQL server from excel | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Import to SQL server from excel

Im a complete beginner in the world of SQL Server and was wondering if someone can tell me if its possible to have a SQL server table updated automatically by importing data from an excel spreadsheet? Would it be possible to schedule this task to happen every day at a certain time?
The data will always be in the same format just adding records. I’ve heard of something called DTS – is this the way to go?
yes, use DTS. you can accomplish this with the Import/Export wizard. Choose Excel as your source. If you wish to automate it chose the "Schedule Package For Execution" option towards the end of the wizard. Tom Pullen
DBA, Oxfam GB
KBA to import from Excel and KBA;en-us;306125&sd=tech to import to Excel – to support what Tom referred. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.