Solved

CSV export specification in Access 2007

Posted on 2009-04-02
7
4,322 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help writing a query 6 71
data analyst 3 49
Problem with syntax with TransferDatabase 3 14
how to address a subform in a form, from inside another subform 2 22
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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 …

910 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