메뉴 건너뛰기

kode2.com

Excel Data를 MSSQL로 import시 에러 발생

2019.02.16 15:59

kode2 조회 수:41

http://support.microsoft.com/kb/281517/EN-US/.

 

PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow Error

 

"Error at source for row number 9.Errors encountered so far in this task :1"
General Error: -2147217887(80040E21)
Data for Source Column 3('Col3') is too large for the specified buffer size.

 

 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel

 

TypeGuessRows 값을 0로 설정 후 import