Link to home
Start Free TrialLog in
Avatar of Larry Rungren
Larry RungrenFlag for United States of America

asked on

sql server import/export utility

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???
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

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.
Avatar of Larry Rungren

ASKER

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
Avatar of Rich Weissler
Rich Weissler

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.
The target table is there and has been for 10 years.  Why is the utility only allowing create file and load process?
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.
here is the series of screen shots from start to finish with the error detail
sorry attach didn't work
one more try
Are you saying that [dbo].[udmarketingmast] exists already?
(and: are you certain that 10 year old table does not belong to a different owner?)

User generated image
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)
User generated image
ASKER CERTIFIED SOLUTION
Avatar of Larry Rungren
Larry Rungren
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I hadn't heard anything that corrected the issue so I simply rebooted and it cleared problem.