Adding data to SQL Server 7 from Excel
This is best done within SQL Server. In Enterprise Manager, take a
look at Data Transformation Services. If you do not have access to the
server tools (i.e. you only have a client connection), you may be able
to use a SELECT..INTO query to create a new table, however your
permissions may only allow you to create a temp table.
--
"Rich" wrote in message ...
Hello,
My apologies if this is not the correct/best place for this posting.
I am pretty new to database programming. I have a spreadsheet which
contains industry SIC codes which I obtained from the SEC.Gov website. I am
trying to get this data (about 450 rows in Excel) into a table in SQL Server
7.0. Can anyone give me a little guideance on how to do this?
I have made a connection from Excel to the SQL database using Tools Get
External Data but not sure where to go from there. Are there any other
simple options available for this? I run WinXP and Office XP.
TIA,
Rich
|