Solved

sql server import/export utility

Posted on 2015-02-06
11
58 Views
Last Modified: 2015-03-22
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
Comment
Question by:Jeff_Kingston
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40593721
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
 

Author Comment

by:Jeff_Kingston
ID: 40593739
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
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 40593754
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Jeff_Kingston
ID: 40593762
The target table is there and has been for 10 years.  Why is the utility only allowing create file and load process?
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40593763
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
 

Author Comment

by:Jeff_Kingston
ID: 40593787
here is the series of screen shots from start to finish with the error detail
0
 

Author Comment

by:Jeff_Kingston
ID: 40593790
sorry attach didn't work
0
 

Author Comment

by:Jeff_Kingston
ID: 40593834
one more try
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 40596387
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
 

Accepted Solution

by:
Jeff_Kingston earned 0 total points
ID: 40671145
My apology.  This question was resolved by a simple reboot of the desktop.
0
 

Author Closing Comment

by:Jeff_Kingston
ID: 40680769
I hadn't heard anything that corrected the issue so I simply rebooted and it cleared problem.
0

Featured Post

Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question