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 |
|
rtr1900
Starting Member
48 Posts |
 Posted - 2008-04-24 : 05:24:34
|
| Hi,Ihve a DB file (DBF) and want to import it into SQL server.But following the instruction it crashes and tells me:Error in destination for row 100325. Errors found until no in ask:1Erro in insertion, column4('FEC_STOCK',DBTYP:DBTIMESTAMP), state 6: Overflow data(sorry translated from Spanis)Sowhat I understand is that there is an overflow. How can I reduce that? Using TRIM?ThxJohny |
|
|
rtr1900
Starting Member
48 Posts |
Posted - 2008-04-24 : 09:09:24
|
| I tried first export the file (DBF file) to excel and then import it. ut I loose then the Datetime structure.Also, does SQl has a limit of rows? Cause mostly the error happens when it hit 107000 rows.Thx |
 |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-04-24 : 09:17:52
|
| what is the datatype in your source? is it a valid datetime?Em |
|
|
|
rtr1900
Starting Member
48 Posts |
Posted - 2008-04-24 : 09:57:34
|
quote:
Originally posted by elancaster
what is the datatype in your source? is it a valid datetime?Em
Yes, that is hy I am alsovery surprised. Because there are other colums with the same dattype and there is no problemto import them (leaving the colums tha gives me problems away).Now I have succee importing it, but it is a long way.First I exported the dbf file to an excel file using DBViewer2000. Then in excel I make sure it has the datatype DateTime(dd/mm/yyyy). Then when I can import it into SQL. There I then change the datatype to datetime, and then it works fine....I really can´t figure it out why it just import the file. Maybe it is because of the length? Althought I doubt it very much.For no I got it working, but I am going to try and find out why it won´t import directly.Is there anything I can show you, you might find usefull?Thx already |
|
|
|
|
|
|
Importing file DBF crashes, donm´t know why