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
Solved

sql server import/export utility

Posted on 2015-02-06
11
55 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 48

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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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 48

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Powershell v3 - SQLCMD 3 27
SQL trigger 5 23
Location of Dynamics AX Service accounts in SQL 3 16
SQL 2012 clustering 9 12
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

828 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