Solved

sql server import/export utility

Posted on 2015-02-06
11
52 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 45

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 29

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
 

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 45

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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now