Export date from Excel to SQL Server using ADODB

Question

I got errors converting an Excel date to SQL Server.

Conversion failed when converting date and/or time from character string

rs.open "Table", con, adOpenDynamic, adLockOptimistic, adCmdTable
rs.addNew
rs("DateColumn") = rng.Value

I solved the problem adapting this answer

score 0 · Accepted Answer · answered Oct 21 '19 at 11:21

0

I solved this using this code:

If rng.NumberFormat = "m/d/yyyy" Then
    rs("DateColumn") = CLng(Format(rng.Value, "yyyymmdd"))
End If

answered Oct 21 '19 at 11:21

GUI Junkie

So the issue was in database column setup then? Also, might be worth accepting your answer just to close the question – Zac Oct 21 '19 at 13:00
@Zac The date column is defined as a "date". – GUI Junkie Oct 21 '19 at 13:03

1 Answers1