Importing Excel into SQL Server -

-

i want update table using data excel sheet. excel file have 2 columns, 1 uniqueidentifier , other reference. tried use openrowset command update table, database have security property doesn't allows me it.

my idea create new table in database 2 columns, , update data in table later. create data in database tried use import wizard in sql server when tried it, got following messages:

error 0xc020901c: data flow task 1: there error source - sheet1$.outputs[excel source output].columns[pst_wsi_refdes] on source - sheet1$.outputs[excel source output]. column status returned was: "text truncated or 1 or more characters had no match in target code page.". (sql server import , export wizard)

error 0xc020902a: data flow task 1: "source - sheet1$.outputs[excel source output].columns[pst_wsi_refdes]" failed because truncation occurred, , truncation row disposition on "source - sheet1$.outputs[excel source output].columns[pst_wsi_refdes]" specifies failure on truncation. truncation error occurred on specified object of specified component. (sql server import , export wizard)

error 0xc0047038: data flow task 1: ssis error code dts_e_primeoutputfailed. primeoutput method on source - sheet1$ returned error code 0xc020902a. component returned failure code when pipeline engine called primeoutput(). meaning of failure code defined component, error fatal , pipeline stopped executing. there may error messages posted before more information failure. (sql server import , export wizard)

i know messages refer data, excel file have 12k lines , don't know line has problem.

how investigate line has problem? or, there other ways import data excel?

more information:

sample of data i'm trying import

c7 (op1 op12), c10 (op1 op12), c3 (ip1 ip16), c6 (op1 op12), c10, c11, c12, c45, c49, c50, c14 (op1 op12), c5 (op1 op12), c9 (op1 op12), c15 (op1 op12), c51, c52, c54, c55

max size of field: 1303 characters.

import table format: i've tried 2 configurations:

1 - uniqueidentifier , nvarchar(2000)

2 - nvarchar(200) , nvarchar(2000)

try use excel2mysql, saved me lots of headaches..


Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more