Import Excel file in to a single microsoft SQL table

I

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.
 
what version of SQL-Server?

In 2k, you could right click your table, choose All Tasks, choose Import Data, and follow the prompts.
 
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.
 
You must log in or register to reply here.
Back
Top