Access 2010 simple export into a .csv

[jmyatt]

I have a simple query that pulls two fields from a table. I just want to right click on the query and export the data to a .txt file in CSV format.
I was able to do this in 2003 and XP versions, but 2010 doesn't give the
a prompt to create a export spec.

Any Help???

Thanks

Jay

 

[John Big Booty]

Welcome to the forum.

In Access '10 you need to look under the External Data tab;

... and follow the bouncing ball from there

 

[jmyatt]

Tried that... but it only produces a .xl? file. I need to export the data as a .csv file format. In 2002, sorry to say that is where we are, you can develop the export/import spec while you are doing the export after you right clicked on the query. Is there a way to create a spec file that is not readily apparent?

 

[John Big Booty]

Perhaps this thread will help.

 

[jmyatt]

So I guess a simple function from the older versions of Access has been "improved" to need VBA code?

 

[nanscombe]

1) Right mouse click on the table / query

2) Choose Export then Text File

3) Make sure "Export data with formating and layout" is not checked

Or ...

1) Open your table / query

2) Goto the External Data tab

3) Choose the Text File option

4) Make sure "Export data with formating and layout" is not checked

Either way will take you to the Export Text wizard where you can select your export options.

 

[jmyatt]

Nigel:
thanks... I was interpeting the format button incorrectly. Whoppee!