Linked Table Field Types Steven M. Britton 22.09.2006 15:30:02 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