Adding data to SQL Server 7 from Excel

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

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
 
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.
 
Back
Top