Hi all,

I have a json file that I import into excel.

an example of one of the dates in the json file is 200834905 (this is the value for the user in the example below).

I have been pulling this date and data from other sheets into another sheet using ADO an example of a statement is

SELECT [Result], [Date] FROM [Results$A1:C1012] WHERE [PlayerName] = ' orchidIove? '

the date returned for this user via ADO is "22/05/2022 5:25:21 PM" and 44703.7259375 as a double

So I have no problems with the above but I want to import this information via the json file into an access database.

Using a very similar method (VBA ADO connection in an access database) I attempt to assign a value such as 200834905 from the json file to an access database such as RS("FleetJoinDate").Value = Value(7)

This breaks the code with error "out of present range" which makes sense as the json value is too large to fit in the date data type that the FleetJoinDate field is set to.

I cant CDate the json value and have run out of ideas as to where to go next.

Hopefully this is enough information to convey what is going on.

Any help would be appreciated. Thanks