• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

sql server import/export utility

I have used this process before under 2000, but using SQL Server 2008 when I try to import rows it always tries to create a table and aborts.  Can't this utility allow simple inserts?  There are radio buttons to create or not the destination file, but they are not active???
0
Jeff_Kingston
Asked:
Jeff_Kingston
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you post here a screenshot of the error?
It shouldn't create a table if already exists unless you explicitly choice the option to drop and create table.
0
 
Jeff_KingstonAuthor Commented:
here's the screen and there is no option to set or not the option to create a file prior to this.  If you need, I'll scrren shot the entire process and send.
importerr.docx
0
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
That screen shot does indicate that a new target table will be created.
Confirm that the row you are copying the data into already exists.  From this, it appears that it doesn't.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Jeff_KingstonAuthor Commented:
The target table is there and has been for 10 years.  Why is the utility only allowing create file and load process?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Was expecting the screenshot with the abort error.
Anyway, why you chose an Access provider for an Excel file? There must have an Excel provider as well.
0
 
Jeff_KingstonAuthor Commented:
here is the series of screen shots from start to finish with the error detail
0
 
Jeff_KingstonAuthor Commented:
sorry attach didn't work
0
 
Jeff_KingstonAuthor Commented:
one more try
0
 
PortletPaulCommented:
Are you saying that [dbo].[udmarketingmast] exists already?
(and: are you certain that 10 year old table does not belong to a different owner?)

the only image available here
Not sure where the other attachment is, but perhaps you could just use Insert Image
(the last icon on the right of the comment toolbar)
Insert Image
0
 
Jeff_KingstonAuthor Commented:
My apology.  This question was resolved by a simple reboot of the desktop.
0
 
Jeff_KingstonAuthor Commented:
I hadn't heard anything that corrected the issue so I simply rebooted and it cleared problem.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now