update and insert record in add on table from data in excel

[BHAT100]

Thanks for help

sql server version 2000
great palins 8.0

I don't know how to proceed to update and insert additional record which is at present in excel to new table created in database. I have access to SQL server.

any idea on above would be great help to me

Thanks

-bhat

 

[Catadmin]

The easiest way would be to use the DTS Import/Export wizard and let SQL do the data transformation for you. Anytime you right click a table in Enterprise Manager and choose IMPORT DATA or EXPORT DATA, this wizard automatically activates.

The other way to do it is to use the BULK INSERT T-SQL command (see BOOKS ONLINE) or the BCP command line utility.

If you want to do it the hard way, those would be the way to go. Books Online is usually installed with Client tools in a default install, so you should be able to find it on any desktop with EM or QA (Query Analyzer).

Otherwise, you can find it at:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[jbenson001]

You want to import data from excel into SQL Server?

I would use a DTS package. Refer to books on line for more help.

I believe this would be the easiest way.

 

[BHAT100]

I have tried to import additional data using text file through enterprise manager import/export option ( RIGHT CLICK ON COMPANY'S TABLE). I get all data from text to wizard. when I click next, it comes back bigining of wizard and does not import anything into table.

Any clue on above why is it not importing data

Thanks everybody for help

-bhat

 

[BHAT100]

Thanks, I found the solutions

-bhat