Robert Wardlow
asked on
CSV export specification in Access 2007
I recently upgraded to Access 2007 and can't find a way to export to a csv file either using the UI on the ribbon or in VBA. I expect to use transfer text in VBA but expect I will need to create an export specification. I have done that in the past with 2000 and 2003 but now in 2007 export to csv doesn't seem to be a choice.
thanks in advance for your help
Bob
thanks in advance for your help
Bob
ASKER
Thanks for the comment.
I have done what you recommend. After I save the export steps, there is no advanced button.
Is there some choice somewhere to disable the advanced button?
thanks
Bob
I have done what you recommend. After I save the export steps, there is no advanced button.
Is there some choice somewhere to disable the advanced button?
thanks
Bob
to gain access to the export Specification click the Advanced button **before Finishing** the export.
ASKER
There must be something wrong with my installation.
there is no advanced button. I have now been through the whole sequence several times.
thanks for your help. I need to find out why I have no advanced button.
Bob
there is no advanced button. I have now been through the whole sequence several times.
thanks for your help. I need to find out why I have no advanced button.
Bob
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
maybe it is because you are pressing the tick box to keep current format :)
on the Export Groups select Text File
in the FileName, cahnge the extension to .csv
then just follow the wizard
at the end you can save the export steps
to gain access to the export Specification click the Advanced button before Finishing the export.