I am exporting a csv text file from the results of an access query.
Everything works fine, but the column headings in the text file have illegal
field names in Access. For example Total..Cost Access does not allow me to
have a period in the column name of my query. Is there an easy fix for
this? The file specification for the text file calls for headings with the
period in them. At present, I am creating it without the period, but the
file needs the period to upload properly.

my Code:
DoCmd.TransferText acExportDelim, "", sTable, sFile, True, ""

Surround the Total.Cost text with [ ] characters in the query for the alias
name:

SELECT FieldName As [Total.Cost]
FROM TableName;

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/



"JP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am exporting a csv text file from the results of an access query.
>Everything works fine, but the column headings in the text file have
>illegal field names in Access. For example Total..Cost Access does not
>allow me to have a period in the column name of my query. Is there an
>easy fix for this? The file specification for the text file calls for
>headings with the period in them. At present, I am creating it without the
>period, but the file needs the period to upload properly.
>
> my Code:
> DoCmd.TransferText acExportDelim, "", sTable, sFile, True, ""
>

I get a message stating there are invalid characters. Is there another
method I can use?


"Ken Snell MVP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Surround the Total.Cost text with [ ] characters in the query for the
> alias name:
>
> SELECT FieldName As [Total.Cost]
> FROM TableName;
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
> http://www.accessmvp.com/KDSnell/
>
>
>
> "JP" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I am exporting a csv text file from the results of an access query.
>>Everything works fine, but the column headings in the text file have
>>illegal field names in Access. For example Total..Cost Access does not
>>allow me to have a period in the column name of my query. Is there an
>>easy fix for this? The file specification for the text file calls for
>>headings with the period in them. At present, I am creating it without
>>the period, but the file needs the period to upload properly.
>>
>> my Code:
>> DoCmd.TransferText acExportDelim, "", sTable, sFile, True, ""
>>
>
>

Post the entire SQL statement of the query that you're trying to export.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"JP" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I get a message stating there are invalid characters. Is there another
>method I can use?
>
>
> "Ken Snell MVP" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Surround the Total.Cost text with [ ] characters in the query for the
>> alias name:
>>
>> SELECT FieldName As [Total.Cost]
>> FROM TableName;
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>> http://www.accessmvp.com/KDSnell/
>>
>>
>>
>> "JP" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>I am exporting a csv text file from the results of an access query.
>>>Everything works fine, but the column headings in the text file have
>>>illegal field names in Access. For example Total..Cost Access does not
>>>allow me to have a period in the column name of my query. Is there an
>>>easy fix for this? The file specification for the text file calls for
>>>headings with the period in them. At present, I am creating it without
>>>the period, but the file needs the period to upload properly.
>>>
>>> my Code:
>>> DoCmd.TransferText acExportDelim, "", sTable, sFile, True, ""
>>>
>>
>>
>
>