import Excel file into sql server 2000 table

Posted Date: 21 Oct 2008 Posted By: Badal Sharma Member Level: Silver Points: 1 Responses: 1

How to import Excel file into sql server 2000

i have a table Tbl_Country in my Database=SiteDB

I hav an excel file with this data

ip_from ip_to co_code2 co_code3 co_name
33996344 33996351 GB GBR UNITED KINGDOM
50331648 69956103 US USA UNITED STATES
69956104 69956111 BM BMU BERMUDA
69956112 83886079 US USA UNITED STATES
94585424 94585439 SE SWE SWEDEN

Responses

Author: Sathish 21 Oct 2008

Member Level: Silver

Rating:

Points: 3

Hi

Proceed with the following steps:

1. Open Enterprise Manager
2. Select the database
3. right click & navigate to -> All Tasks->Import Data
4. Proceed with the wizard
5. Select the data source as Microsoft Excel 97-2000
6. Click Next & proceed with other screens
7. Finally click finish

Your data will be ported to the corresponding DB with the table name you have given & the data from the excel.

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Database
	Previous : Query
	Return to Discussion Forum
	Post New Message
	Category: SQL Server

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use