Export Access Table to .txt file

[The_Grudge]

I'm trying to export an Access table to a text file but I'm having one issue.

My date should be formatted as "yyyymmdd" and it appears to be until I export it to the text file. Then Access throws the "/" back in.

How can I stop this?

[DKenny]

Grudge
You can override this by using an Export Specification.


The best way to understand this is to first do a manual export of a table.
1/ Select Table
2/ Select File-->Export
3/ Change the file type to Text File.
4/ Click on Export
5/ On theExport Text wizard there's a button in the bottom left corner titled 'Advanced...' Click on it

This brings up a dialog where you can set all the specifications for your export - including the date delimiter and date Order.

6/ Set this spec up as you need it and then click "Save As...'
This will record your spec with your chosen name in a system table call "MSysIMEXSpecs" - you wwill need to unhide system object to see this table.

Now when you call the export Method you can refer to this specification.

[DKenny]

Sorry Grudge, the last line should read


Now when you call the TransferText Method you can refer to this specification by the name you saved it as, by passing it to the Method in the "SpecificationName" input.