Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
codeman43
Starting Member
2 Posts |
 Posted - 2006-10-20 : 12:09:09
|
Hello,I'm real new to SQL Server 2005 or any database stuff for the most part. I’m learning as I go so bare with me please. I have put together some applications that run on SQL Server 2005 database, so I’ll have some understanding, but I’m still new.With that said and all; I’m trying to import rows from Excel into SQL Server 2005 database. I have imported, but it created a new table and didn't import into the existing table. I have Visual Studio.NET 2005 Team and I’m developing a web page in ASP.NET. However, the import process is manually being done by me.The Excel file has more columns then I need to import and column names are different then that of the database. The database (directory2) has one table (phonebook) with columns ID as int not null, Phone as float, Name and Location as nvarchar(255). In the first row of the Excel file (Ext.,Type, Port, Name, Data Ext., Cover 1, Cover 2, COS, COR, TN, Room, Jack and Cable.) I only need the rows from Ext, Name, and Data Ext to be imported into SQL.Lastly, I do not want to over write rows that have not been updated and it needs to ask before inserting new rows.Any idea how I can go about doing this?Thanks.I want to be a programmer!  |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
|
|
Import into SQL Server 2005 from Execl.