transferring data - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

transferring data

Author

Topic

sgraves
Starting Member

29 Posts

Posted - 2005-08-10 : 09:45:55

Hi! I am trying to import a file from excel into Enterprise Manager. I have found the wizard that does this, but I can't seem to find the table I want to import the file into. What am I doing wrong? Thanks for any help you can give.

Scott

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-10 : 09:54:37

First you have to create the target table if it is not there and then try again
Here is a method to do it from query
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

sgraves
Starting Member

29 Posts

Posted - 2005-08-10 : 10:14:42

I have a target table. I just can't find it. I am also importing data from an excel file into the Enterprise Manager not Sequel to Excel. Any ideas? Thanks for your help.

Scott

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-10 : 10:24:32

How do you do this>
Right click on the database->All tasks->Import data->Choose Data source as Excel
Then choose server and database ->Choose Destination table
The Linked I specified will also do the same
Read it fully

Madhivanan

Failing to plan is Planning to fail

sgraves
Starting Member

29 Posts

Posted - 2005-08-10 : 10:26:17

Ok, maybe I should be more clear. This is what I have tried to do. I have open Enterprise Manager, I found my table, right clicked on it and chose import data. I got the wizard. I selected my excel file to import. I think I found the destination, but it doesn't have the name of my table as the destination. I think this is where I am having trouble. When I do the import, it says it imported fine, but I can't find the information after the import. Any ideas?

Thanks!

Scott

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-10 : 10:30:16

Refresh the database and check it again

Madhivanan

Failing to plan is Planning to fail

sgraves
Starting Member

29 Posts

Posted - 2005-08-10 : 10:37:12

I just refreshed, but I still dont' see the info. My destination show: Microsoft OLE DB Provider for SQL Server. Is this right? I was thinking, no. I want it to be the table, but it's not listed. My server and database names are correct. What you think?

Thanks!

Scott

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-10 : 10:47:14

Yes. You can see the new table in the table list same as that of Excel name. Check that name

Madhivanan

Failing to plan is Planning to fail

sgraves
Starting Member

29 Posts

Posted - 2005-08-10 : 10:50:09

Under destination, I don't see the table name. What am I doing wrong?

Thanks!

Scott

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-10 : 10:57:04

No You cannot see it
The thing is that after you imported the data, refresh the Database and You can see the new table which is same as Excel Filename

Madhivanan

Failing to plan is Planning to fail

sgraves
Starting Member

29 Posts

Posted - 2005-08-10 : 11:04:52

Ok, now I really confused. I don't want to create a new table. I want to import data into an existing table which already contains data. I want to import data from an excel file into an existing table. This is where the table lies: Databases/CLB/Tables/Agent

I want to import the excel data into the table named Agent, but I don't know where to look to choose the destination of Agent Table.

Sorry to be such trouble.

Thanks for your help.

Scott

sgraves
Starting Member

29 Posts

Posted - 2005-08-10 : 12:13:34

What happened? No more replies. Please help!!!!

Thanks!

Scott

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-11 : 00:54:33

>>. I want to import data into an existing table which already contains data.

Refer this and see the third query

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

svicky9
Posting Yak Master

232 Posts

Posted - 2005-08-11 : 06:24:52

just check the table called "results" in all the databases...most probably in master database
Try that
that must be the imported table

Vicky

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-11 : 06:30:01

quote:
Originally posted by svicky9

just check the table called "results" in all the databases...most probably in master database
Try that
that must be the imported table

Vicky

Thats not the solution the questioner expect
The only way is to follow the link I specified

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources