Larry Rungren
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???
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
importerr.docx
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.
Confirm that the row you are copying the data into already exists. From this, it appears that it doesn't.
ASKER
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.
Anyway, why you chose an Access provider for an Excel file? There must have an Excel provider as well.
ASKER
here is the series of screen shots from start to finish with the error detail
ASKER
sorry attach didn't work
ASKER
one more try
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I hadn't heard anything that corrected the issue so I simply rebooted and it cleared problem.
It shouldn't create a table if already exists unless you explicitly choice the option to drop and create table.