Search results

[SOLVED] pass correct date in sql string, tried all the obvious The insert of the date itself works fine now and for the retrieval of the period number I've found a workaround: a sql server stored procedure does an update using a simple, unformatted between statement. works perfect.

I think I've sorted the insert value itself "insert into dbo_Skilldata (SpelerID, Wiel, Datum, SkillID, AbsScore, SkillScore, Snapshot, TestPeriode) select CLng(F2), dbo_spelers.wiel, format(cdate(F1), ""mm/dd/yyyy""), " & VSkillid & " , " & vKolomscore & " , dbo_Normering.skillscore...

insert into dbo_Antropometrie (SpelerID, Datum, Lengte, Gewicht, Schoenmaat, Voetbreedte, SitReach, Zithoogte) select F2, format(cdate(F1), JetDateFmt ), F3, Replace(F4,".",","), Replace(F5,".",","), F6, Replace(F7,".",","), F8 from AntroImport Same error :(

I don't get that far unfortunately: insert into dbo_Antropometrie (SpelerID, Datum, Lengte, Gewicht, Schoenmaat, Voetbreedte, SitReach, Zithoogte) select F2, format(F1, JetDateFmt ), F3, Replace(F4,".",","), Replace(F5,".",","), F6, Replace(F7,".",","), F8 from AntroImport Result is an...

Thanks. I've seen this one before but could not make it work. I see you mention "module" while my code is launched from a form and button. Should the Global Const be set up somewhere else? Where to call it from then?

Dispite all the suggestions, the issue remains unresolved. Any further suggestions are very welcome.

Sorry.....Compile error, double quote before F1 is seen as end of string. (can't run debug)

insert into dbo_Antropometrie (SpelerID, Datum, Lengte, Gewicht, Schoenmaat, Voetbreedte, SitReach, Zithoogte) select F2, ##, F3, Replace(F4,".",","), Replace(F5,".",","), F6, Replace(F7,".",","), F8 from AntroImport "& F1 &" are gone??

Ah, didn't see that one appearing while replying. No luck: Syntax error in date in query expression '#'.

I've copied your code: strsqlA4 = "insert into dbo_Antropometrie (SpelerID, Datum, Lengte, Gewicht, Schoenmaat, Voetbreedte, SitReach, Zithoogte) select F2, "#" & F1 & "#", F3, Replace(F4,""."","",""), Replace(F5,""."","",""), F6, Replace(F7,""."","",""), F8 from AntroImport" Access VBA...

Source data has been checked. In fact, it has been altered to have a complete test scenario. "#" & F1 & "#" results in a Expected: end of statement ""#"" & F1 & ""#"" passes NULL values into the table the replaces are to deal with wrong decimal notification (from source data being a Google...

Hi, thanks for replying. I test your code and got a syntax error: syntax error in date in query expression '# & format(F1, 'mm\/dd\/yyyy') &'. (note that the message is excluding the second hash from the code)

Hi, having queried and tested endless options, I can't get a succesfull entry of dates in their correct format into a linked SQL Server table via Access VBA. Situation is that I have an Access table ("AntroImport") which holds data imported from an Excel sheet. First colum holds a date/time...

Hi AWF, I've read and tried to understand various topics regarding Access bloating on AWF and via Google, yet fail to come to grips on how to deal with it in my particular problem. Let me explain: a 3rd party programmer has provided a lengthy code to process (even lengthier) xml messages...