?
Solved

CSV export specification in Access 2007

Posted on 2009-04-02
7
Medium Priority
?
4,336 Views
Last Modified: 2013-11-27
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
0
Comment
Question by:Rwardlow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24054304
click on External Data
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.
0
 
LVL 1

Author Comment

by:Rwardlow
ID: 24054516
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
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24054536


to gain access to the export Specification click the Advanced button **before Finishing** the export.
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 1

Author Comment

by:Rwardlow
ID: 24058830
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
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24058951
see this image


ExportWindow.jpg
0
 
LVL 1

Accepted Solution

by:
Rwardlow earned 0 total points
ID: 24059289
My problem is that this window doesn't come up. The export dialog ends without this window and without the advanced button in any other window.

When I step through a text export I don't get any choices. I only get to name the file and then the export comletes without giving me any choices.

I am going to try to re-install Office

Thanks,
Bob
0
 

Expert Comment

by:stjohnqld
ID: 25066217
maybe it is because you are pressing the tick box to keep current format :)
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question