View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich[_21_] Rich[_21_] is offline
external usenet poster
 
Posts: 1
Default Adding data to SQL Server 7 from Excel

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