importing data from excel sheet to ms sql

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Murtaza Mustafa - 09 Apr 2005 08:59 GMT

Hi,

I have some excel sheets that contains too much data in it. What i need is
to import the relevant data from it and store it into my ms sql database
tables.

If anyone have some idea of how could i recognise the relevant data I need
from those excel sheets and import it to ms sql databse tables then please
help me in this.

Regards

Reply to this Message

Daniel Wilson - 20 Apr 2005 18:00 GMT

In SQL Server's Enterprise Manager, drill down to the Tables view,
right-click and choose All Tasks | Import Data. This will let you choose
Excel files and import a given worksheet as a new table.

Eliminating the irrelevant data will probably be easier once it is in SQL
Server. Delete From MyTable Where ... whatever ... possibly where a given
field is null.

hth

Signature

Daniel Wilson
Senior Software Solutions Developer
Embtrak Development Team
http://www.Embtrak.com
DVBrown Company

> Hi,
>
[quoted text clipped - 7 lines]
>
> Regards

Reply to this Message

VB Forum / COM / April 2005

importing data from excel sheet to ms sql