Right so i spent 3 days at work to get my data in the correct format to upload into the database
fortunatly it pushed in with out errors
but the Date had to be forced in as text, then changed to date time in design view
now when i query the database on a date condition it wont work
i.e...