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
KBAhttp://support.microsoft.com/?kbid=321686 to import from Excel and KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;306125&sd=tech to import to Excel – to support what Tom referred. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>