1. Forum
  2. Usenet
  3. COMP.DATABASES.MS-ACCESS

  • Required column name not compatible with Access naming convention

    From Ron Weiner@21:1/5 to musicloverlch on Wed Jul 29 12:10:30 2020
    musicloverlch wrote :
    Hi,

    I have to export a CSV file from Access and one of the columns has to have the name of vest.10 which Access doesn't allow. How in the world am I going to accomplish that? I'm stumped.

    Thanks,
    Laura

    Try Puttin the string inside of square Brackets IE: [vest.10]

    If that dosent work show us your code/querry

    Rdub

    --
    This email has been checked for viruses by AVG.
    https://www.avg.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From musicloverlch@21:1/5 to All on Wed Jul 29 09:01:04 2020
    Hi,

    I have to export a CSV file from Access and one of the columns has to have the name of vest.10 which Access doesn't allow. How in the world am I going to accomplish that? I'm stumped.

    Thanks,
    Laura

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From musicloverlch@21:1/5 to musicloverlch on Wed Jul 29 09:28:12 2020
    On Wednesday, July 29, 2020 at 11:23:40 AM UTC-5, musicloverlch wrote:
    Unfortunately, it's not a field in the table, it's the name of the column. When I try to make it a column name it says that it isn't a valid column name.

    Here's the error: https://www.dropbox.com/s/dge2nly0q0ow9sn/error.png?dl=0

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ron Weiner@21:1/5 to All on Wed Jul 29 12:39:06 2020
    It happens that musicloverlch formulated :
    On Wednesday, July 29, 2020 at 11:23:40 AM UTC-5, musicloverlch wrote:
    Unfortunately, it's not a field in the table, it's the name of the column. >> When I try to make it a column name it says that it isn't a valid column
    name.

    Here's the error: https://www.dropbox.com/s/dge2nly0q0ow9sn/error.png?dl=0

    Is the Column name error coming from output of a query?
    As in Select thisthing, ThatThing as vest.10 From ...
    If so, change it to:
    Select thisthing, ThatThing as [vest.10] From ...

    Otherwise, I don't get it, you'll have top share more of wha tyou are
    doing. A picture of a error dialog is not much help.

    Rdub

    --
    This email has been checked for viruses by AVG.
    https://www.avg.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From musicloverlch@21:1/5 to All on Wed Jul 29 09:23:36 2020
    Unfortunately, it's not a field in the table, it's the name of the column. When I try to make it a column name it says that it isn't a valid column name.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Albert Kallal (Access MVP)@21:1/5 to All on Sun Aug 23 19:03:20 2020
    What you can do is create a query against the table. You can even do this in the query builder.

    So, drop into the query grid all the columns from the table (this is nice, since you don't have to export all colums).

    This approach is also great, since you can "change" the name(s) of exported columns.

    So say you have MyVest for the column in access

    In the query builder where the field name is:

    Type in this:
    [vest.10]: MyVest

    So, now you can test the query. And now save it. So, just use the query for the export in place of the table. This allows you to rename one, or many columns.

    Regards,
    Albert D. Kallal (Access MVP 2003-2017)
    Edmonton, Alberta Canada

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From musicloverlch@21:1/5 to All on Tue Sep 1 07:28:44 2020
    Thank you so much!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)