How to create a csv file with select Access fields?

J

JWise

Would like to be able to create a csv file that selects only certain fields
from an Access table. Don't want to export all fields, just a few. Can this
be done?
 
D

Duane Hookom

I'm not sure why you would need to make a table when you can export a query
to a text file.
 
J

JWise

I guess I don't know much about Access, because I don't know how to
selectively export only certain fields to a text file. Can you explain?
 
V

Vincent Johns

JWise said:
I guess I don't know much about Access, because I don't know how to
selectively export only certain fields to a text file. Can you explain?
Click to expand...

On the Database window, select Queries, then "Create query by using
wizard", then follow the directions to specify the table and the fields
you want to export. When you finish, if you like what you see in its
Datasheet View, close that and right-click on the new query's name. On
the pop-up menu, choose "Export...". On the Export wizard, choose text
file type, then follow the directions to specify how you want it formatted.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Top