No Advanced button on CSV Export wizard

[sparkycfc]

Hi,

I'm trying to write a simple line of code to export a record in my query using DoCmd.TransferText acExportDelim. Only i'm having problems with the specifications.

Everywhere I go it tells me that in order to do this I need to do a manual export and click advanced on the wizard and save the specification. But there is no advanced button in my wizard....??

At the end it asks me if I want to save the steps so I do, then I try and call this in the code, but it says the specification cannot be found. I doubt that's meant to work but i'm clutching at straws as I can't follow anyones instructions as i have no Advanced button.

Any help? i'm using access 2007.

Thanks

 

[gemma-the-husky]

i'm not familiar with the interface in A2007 - but when you

file, export, etc in other versions

when you save as a csv, you get an advanced button, that lets you pick separator, and text mask etc, include text header etc.

in this there is a save spec button, which lets you save the settings as a named file spec.

I think you must just be not noticing the save button at the appropriate stage.

 

[sparkycfc]

there is a "save these steps" button at the end, which could be the 2007 equivalent, but when i try and call the name i saved it to it says it doesn't exist.

Plus i can see no way of changing the seperators, text headers etc etc

 

[Kiwiman]

Howzit

Not sure if the "Advanced Option" is availble in exporting?

What I do is import the file format first (by manually copying the table and saving as the required output, then importing back in), which will then have the Advanced option available, where you can set the options and save the specification.

You can use the same spec for the export expression.