Recent content by Nitescar

That would work as well I will see if I can figure that out, been trying to teach myself access for the last week or so. Thank you much for the help.

To give a little background I import a table every morning from an excel spreadsheet exported from an Oracle database that contains datetime fields, if the first row of one of these fields is null then it imports to Access as text (The table is deleted first, then readded). With this I have to...