Access97 wrong format on export as csv-file

[frag]

Hi!

I have a major problem here. There is a table I have to export as csv-file. But whenever I try to do this the result is that all dates in the file have the time 00:00:00 at the end. But in the table they are formated as Date/Time Short. Another problem are numbers like -0.00297 they will get exported as -2.97e-03... which is correct but in the wrong format. I want the number as it is in Access.

The strange thing is... everything looks fine in the preview window while making the setup for the export but in the file it's messed up liked described above.

Is this a config problem or a bug or what?

Cheers

frag

patrick.metz@epost.de

 

[EliseFreedman]

Try creating a query based on the table. Then export this query to CSV Format. In the Time/Date Field in the query try

Format([data]![SrceDate], "Short Date")

 

[frag]

Could you please go a bit more into detail?

A query on the database would be "Select * from <Table>". Where should I place the "Format([data]![SrceDate], "Short Date")" ?



patrick.metz@epost.de

 

[EliseFreedman]

SELECT Table1.*, Format([Table1]![Time],"Short Date") AS Expr1 FROM Table1;

 

[frag]

Thank you for the tip Elise but this won't do the trick... same result as before.

I think I have to stick to my previous tactic and change every field in the database to a text-value.

By the way... same problem with Access 2000.

Thank you Microsoft for another wasteful function in an Office application.



patrick.metz@epost.de

 

[scottian]

sounds to me like you need to look at the export spec

Be ALERT - Your country needs Lerts

 

[frag]

@scottian: my export specs are ok. anyway there is not much that can be configured wrong, isn't it?

patrick.metz@epost.de