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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-30 : 16:58:38
|
chetan writes "Hi team,
I am using SQLv7.0 running on winnt4.0 sp4 op5. I am working on a project where we had to import lots of tabular data form html files. We imported the data into msaccess 97 via msexcel. After this we imported the data finally to MSSQL into some temporary tables. Now my problem is that the data contained in these temporary tables contain fields that I do not require in my database table. That is to say I need only data contained in certain fields to be added to the my actual table.
How can I selectively insert tablular data from my temporary tables into my actual table. Say I have a database table named X with 4 fields (int,varchar,varchar,varchar) and my temporary table containing data imported from msaccess has 5 fields.
I want only data contained in 4 fields from the temporary table to be inserted into the database table X.
Bye n thanx"
|
|
|
|
|
|
selective insert frm one table to another??