Solved

CSV export specification in Access 2007

Posted on 2009-04-02
7
4,320 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
  • 3
  • 3
7 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
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 119

Expert Comment

by:Rey Obrero
ID: 24054536


to gain access to the export Specification click the Advanced button **before Finishing** the export.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
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 119

Expert Comment

by:Rey Obrero
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now