Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

sql server import/export utility

Posted on 2015-02-06
11
Medium Priority
?
62 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 52

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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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 52

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
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 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.

604 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