Is there a wizard to export and match fields?

[ZenMasta]

I would like to export products from my table into a csv that has different
field names. Is there a wizard that would allow me to select which fields to
export and what fields they match up to in the new file?

 

[Roger Carlson]

Instead of exporting a table, create a query and alias the field names to
the ones you want in the CSV, then export the query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[ZenMasta]

How do you alias field names? Can I do this in design view when I create the
query?

 

[Roger Carlson]

Yes. In general, it is Alias: Fieldname. Suppose your field is called
"LName" and you want it to export (or display for that matter) as "Last
Name", you'd do this in the Design View-

Last Name: LName

Last Name will display as the column head.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L