Error when Importing

[Taff]

Has anyone come across the following?

I have a table with several date fields. Next I have a query where I format the date fields so they can be exported in the correct format. I do this in my query as follows:-

Date1: Format ([DATEBRTH],"ddmmyyyy")
Date2: Format ([DATESTRT],"ddmmyyyy")


When I export the file, I save it as a Fixed Width text file. This text file is then sent off were some changes may be made. The problem I am having is trying to import the text file.

The date fields in my table are dd/mm/yyyy and the format of them in my text file are ddmmyyyy so when I try to import them back into my table, I get errors and the entire date rows are lost.

So what I think I need to do is somehow format the date fields from the text file before they reach the table.

Is there anyway to do this?

Thanks for any help.

Ant.

 

[CBragg]

I know its a bit of a hassle, but the only suggestion i can come up with would be to split the dates into 3 seperate rows and export them, then when you import it back merge the 3 sperate rows back into one with query.

The only issue with this would be in the actual text file you are editing, as the date would be split into three columns.

Maybe someone will post a more efficeint answer.

 

[Taff]

Hi CBragg,

Thanks for the speedy reply. Unfortunately I can't do that as the database that the information is exported to cannot except it.

However that was one of the ways I thought about importing it back in. Split the dd part of the date into one row, mm another and yyyy into the last and then concetenate them.

This seems to be a long way of getting around it, as with some of my tables I have upto 10 date fields.

Ant.