Import Excel spreadsheet columns into SQL Server database

Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

Import Excel spreadsheet columns into SQL Server database

Message par Clippy »

I have an Excel spreadsheet that I want to import select columns into my SQL Server 2008 database table. The wizard didn't offer that option.

Do any easy code options exist?
Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

Re: Import Excel spreadsheet columns into SQL Server database

Message par Clippy »

Once connected to Sql Server 2005 Database, From Object Explorer Window, right click on the database which you want to import table into. Select Tasks -> Import Data.
This is a simple tool and allows you to 'map' the incoming data into appropriate table.
You can save the scripts to run again when needed.
Répondre

Revenir à « Excel & VBA »