Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Upload from Excel to SQL Server | Excel Discussion (Misc queries) | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
Getting data from SQL Server into Excel | Excel Programming | |||
Post Excel Data to a Web Server | Excel Programming |