Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ed9teen
Starting Member
6 Posts |
 Posted - 2008-01-11 : 09:11:29
|
| hi, why this give me this error...Msg 8152, Level 16, State 13, Line 1String or binary data would be truncated.The statement has been terminated.INSERT INTO magpatoc.dbo.RSOTransfer(RSONO, Customer, ItemCode, ItemDescription, Source, MOQ, QuantityRequired, Remarks, ZeroStock, NewProduct, ProjectForecast, WithMotherPO, Other, RequestedBy, RequestedDatetime, NotedBy, RecievedBy, RecievedDatetime, PreparedBy, PreparedDatetime, ApprovedBy, ApprovedDate, ReservationNoDate, PurchaseOrderNo) SELECT *FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\CopyOfRSODB.mdb';'admin';'', FinalCustItemRSO)help please..ed9teenMagnaza |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-11 : 09:13:51
|
| One of the character columns of SQL Server table doesnt have enough length. You need to increase the lengthMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
|
|
need help.insert into sql server frm access table