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 |
|
markwest05
Starting Member
12 Posts |
 Posted - 2007-06-09 : 20:34:12
|
| Hi,On SQL 2005 I am trying automatically through the import 'wizard' import data from excel into an existing table that I have created. I can't find a way to do this without creating a new table. Any takes? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-09 : 21:12:17
|
| You can choose existing table, similar to sql2k's wizard. |
 |
|
|
markwest05
Starting Member
12 Posts |
Posted - 2007-06-09 : 21:16:31
|
The wizard in SQL 2005 doesn't give an option for existing table--unless I am missing anything. Does anyone have step by step instructions on how to import an excel file into an existing sql table using either the wizard or coding? quote:
Originally posted by rmiao
You can choose existing table, similar to sql2k's wizard.
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-09 : 23:05:28
|
| Just click on destination, it'll list existing tables. Works same way as sql2k's data export wizard. |
|
|
|
markwest05
Starting Member
12 Posts |
Posted - 2007-06-09 : 23:14:55
|
| I am trying to import data 'from' excel 'to' SQL 2005. You said just click on destination, the window that gives destination allows me to select the server, then on the bottom, it says "database" which allows me to select the database. However, there is no option to select an existing table. Any suggestions? |
|
|
|
markwest05
Starting Member
12 Posts |
Posted - 2007-06-09 : 23:26:00
|
| Actually I see where you are talking about, I appreciate it friend |
|
|
|
|
|
|
SQL '05 Import Excel data