rename a field before or after exporting as a csv file

[Hfnet]

I am exporting a temporary table's contents to a csv file, with a small problem:

The website we are importing the csv file into insists on specific field names, the first one being "Name".

Obviously, being a reserved name, I cannot call the field "Name" in the temp table, to I have called it cName, and people have to remember to edit the csv file.

Is there any way to either rename the field in the tmep table, or similar, before exporting, or a way from within Access to rename the field name in the csv file automatically?

 

[mp9]

Why not create a query of the form

SELECT SpecificField AS Name FROM TableNameHere

and export the query instead?

http://www22.brinkster.com/accessory/

 

[PHV]

I cannot call the field "Name" in the temp table
Really ?
I think you can ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Hfnet]

Well, I can call it Name, but when you try to add data it throws up an error saying syntax error in.....

Thanks for the query idea, sounds like a do-er.

 

[JerryKlmns]

Have you used [Name] instead of Name like

INSERT INTO Table2([Name])
FROM Table1([Name])
WHERE [Name] Is Not Null;