Import Excel file in to a single microsoft SQL table

iansilv

Limp Gawd
Joined
Jun 10, 2004
Messages
335
I have what is inevitably a stupid noob question, but don't know, so here goes...

How do a I take an excel spreadsheet and import it to fill the data of a sql table? I ahve the entire spreadsheet setup with column headers matching the names of the table column headers, and i just want to "pour" this spreadsheet in to the table.

Also, i need to wipe out all the data in the current table, but keep the column header names.

Any help would be appreciated- thank you.
 

Pwyl_The_Destroyer

Limp Gawd
Joined
Aug 22, 2005
Messages
139
what version of SQL-Server?

In 2k, you could right click your table, choose All Tasks, choose Import Data, and follow the prompts.
 

mikeblas

[H]ard|DCer of the Month - May 2006
Joined
Jun 26, 2004
Messages
12,776
It's the tool that I wrote when I was on the SQL Server team. It's used to migrate data from one place to another; like from Excel into SQL Server.

It's described in Books Online, and you can also read about it in the product's home page.
 
Top