TerryNL
Starting Member
21 Posts |
Posted - 2008-04-17 : 03:25:24
|
Hi thereI have a problem with my insert statementi have an access database and a SQL server databasei want to move the data in the access database to the sql databasethis 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...cellijnnotice that CELLIJNBACKUP... is the name of my linked serverwhen i excute this i get the following error:Server: Msg 8114, Level 16, State 8, Line 2Error converting data type DBTYPE_DBTIMESTAMP to datetime.the column that cant be converted is "geboorte-datum" to dateOfBirthanyone who know how to solve this?thanks! |
|