Exporting To Paradox With A Valid Date Field?

Hi,

I need to export a table from Access to a Paradox DB file for use with an ancient program that unfortunately we're still running. The problem I have is that the table must be created precisely as stated in the programs manual, which means the fields must not only be named exactly but also the type and size.

I've managed to do this...almost, the only problem I have at the moment is that I can't get Access to export date fields that Paradox will see as a date field, Paradox reads them as a timestamp field. I've tried setting them as a short date, integer or formatted text but Paradox simply won't accept them as a date type.

The whole purpose of this exercise is so Paradox won't even need to be opened if I can export this table correctly, but at the moment the only way to sort it is to open Paradox and change the field types manually.

Does anybody have any clue how I can successfully export a date field from Access that Paradox will see correctly? Ironically there isn't even any data being stored in these date fields, but the program won't run unless they exist and are of type D!

Cheers,

Andy