S
Steven M. Britton
I've looked everyone and need someones help please. I have a linked table
which is from a Lotus Notes .nsf database. When I link it into Access it jus
doesn't quite get all of the field types correct and I don't know how to fix
it - Is there a way in ADO through VBA to just select the info I want into a
recordset so I can parse it from there into a local table?
What happens is I there is a field in the .nsf database that contains this:
ACAssignedDate: 03/13/2006 09:52:34 AM,03/13/2006 02:00:10 PM,03/14/2006
08:40:31 AM,03/14/2006 12:52:34 PM,05/09/2006 06:23:20 AM,12/31/1969 04:00:00
PM
But access reads this and makes the field type Date/Time only loading the
first. I want to capture this into an Array and split it on the comma to
then normalize it into a local table...
Ideas?
-Steven M. Britton
which is from a Lotus Notes .nsf database. When I link it into Access it jus
doesn't quite get all of the field types correct and I don't know how to fix
it - Is there a way in ADO through VBA to just select the info I want into a
recordset so I can parse it from there into a local table?
What happens is I there is a field in the .nsf database that contains this:
ACAssignedDate: 03/13/2006 09:52:34 AM,03/13/2006 02:00:10 PM,03/14/2006
08:40:31 AM,03/14/2006 12:52:34 PM,05/09/2006 06:23:20 AM,12/31/1969 04:00:00
PM
But access reads this and makes the field type Date/Time only loading the
first. I want to capture this into an Array and split it on the comma to
then normalize it into a local table...
Ideas?
-Steven M. Britton