Solved

sql server import/export utility

Posted on 2015-02-06
11
54 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
11 Comments
 
LVL 47

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 47

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 48

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

778 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