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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Error converting data type DBTYPE_DBTIMESTAMP to d

Author  Topic 

TerryNL
Starting Member

21 Posts

Posted - 2008-04-17 : 03:25:24
Hi there
I have a problem with my insert statement
i have an access database and a SQL server database
i want to move the data in the access database to the sql database
this is my query:

insert into CellLine (cellLineNumber, firstName, lastName, gender, dateOfBirth, familyCode, disease, cellType, remarks, edta,
heparin, sender, investigator, arrivalDate, affectedNotAffectedCarrier, correspondence, neurologyNumber, liquidNitrogen,
numberOfVials, specificationsSender, culturingFormsCreated, transportDataFormCreated, probandRelative, mutationFormCreated,
addressFormFilledIn, bloodWithdrawlDate, radboudNumber, dnaDiagnosticsNumber, cytogeneticsNumber, additionalInformation,
SpecificationsDiagnosis, clinicalGeneticsNumber, informedConsentAtCellCulture, informedConsentWithSender, informedConsentWithInvestigator,
noInformedConsent)
select cellijnnummer, voorletters, naam, geslacht, "geboorte-datum", "familie-code", aandoening, celtype, opmerking,
edta, heparine, afzender, onderzoeker, "datum binnenkomst", "A_D_NA", correspondentie, "(neuro)nummer", stikstof, "aantal-N2",
"specificatie-afzender", "uitgevoerd 1", "uitgevoerd 2", "proband/relative", "uitgevoerd 3", ingevuld, "datum bloedafname",
radboudnummer, "dna-diagnostieknummer", cytogeneticanummer, briefgegevens, "specificatie diagnose", "klinische geneticanummer",
"informed consent bij ons", "informed consent bij afzender", "informed consent bij onderzoeker", "geen informed consent"
from CELLIJNBACKUP...cellijn

notice that CELLIJNBACKUP... is the name of my linked server
when i excute this i get the following error:

Server: Msg 8114, Level 16, State 8, Line 2
Error converting data type DBTYPE_DBTIMESTAMP to datetime.

the column that cant be converted is "geboorte-datum" to dateOfBirth
anyone who know how to solve this?

thanks!

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-04-17 : 05:48:56
http://forums.databasejournal.com/showthread.php?t=34278

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

TerryNL
Starting Member

21 Posts

Posted - 2008-04-17 : 07:29:15
I have solved the problem myself..

http://www.simple-talk.com/community/blogs/damon_armstrong/archive/2006/08/15/1666.aspx

the problem with the database was that there was a date with the year 1073
it had to be 1973
Go to Top of Page
   

- Advertisement -