Txt type

Nadine
Nadine Altair Community Member
edited September 2020 in Community Q&A
Hi Guys,

Is there a way to change a data field to short text and not long text when you are exporting to access


Thanks in advance

Nadine

------------------------------
Nadine Ryan
Team Owner
Easi Solutions
Tuam
00353872504753
------------------------------
Tagged:

Answers

  • Steve_Caiels
    Steve_Caiels
    Altair Employee
    edited September 2020
    Hi Nadine,

    Unfortunately not.  The only control you have is with the field types in the Classic or DPS table (Memo, Text, Numeric, Date/Time)

    What problems is it causing? Maybe there is a way around it.

    Regards,
    Steve.




    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-03-2020 04:43 AM
    From: Nadine Ryan
    Subject: Txt type

    Hi Guys,

    Is there a way to change a data field to short text and not long text when you are exporting to access


    Thanks in advance

    Nadine

    ------------------------------
    Nadine Ryan
    Team Owner
    Easi Solutions
    Tuam
    00353872504753
    ------------------------------
    "
  • CPorthouse
    CPorthouse
    Altair Employee
    edited September 2020
    Steve is correct that the only thing you have control over are the data types (Character, Memo, Numeric, Date/Time).  I did do a quick test in Monarch Classic (v16 aka v2020) and if the data type is set to Character, it will export as Short Text.  Memo fields export as Long Text.

    *EDIT
    I went back and tried the same thing in Data Prep Studio (v2020) and it appears both character and memo fields are exported as "Long Text" for both .MDB and .ACCDB files.  After some research, this is expected behavior inside of DPS.  The workaround would be to either do everything in Monarch Classic or export your DPS table and then open that export in Monarch Classic.


    ------------------------------
    Chris Porthouse
    Senior Professional Services Consultant
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-03-2020 04:43 AM
    From: Nadine Ryan
    Subject: Txt type

    Hi Guys,

    Is there a way to change a data field to short text and not long text when you are exporting to access


    Thanks in advance

    Nadine

    ------------------------------
    Nadine Ryan
    Team Owner
    Easi Solutions
    Tuam
    00353872504753
    ------------------------------"
  • Nadine
    Nadine Altair Community Member
    edited September 2020
    Chris Porthouse said:

    Steve is correct that the only thing you have control over are the data types (Character, Memo, Numeric, Date/Time).  I did do a quick test in Monarch Classic (v16 aka v2020) and if the data type is set to Character, it will export as Short Text.  Memo fields export as Long Text.

    *EDIT
    I went back and tried the same thing in Data Prep Studio (v2020) and it appears both character and memo fields are exported as "Long Text" for both .MDB and .ACCDB files.  After some research, this is expected behavior inside of DPS.  The workaround would be to either do everything in Monarch Classic or export your DPS table and then open that export in Monarch Classic.


    ------------------------------
    Chris Porthouse
    Senior Professional Services Consultant
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-03-2020 04:43 AM
    From: Nadine Ryan
    Subject: Txt type

    Hi Guys,

    Is there a way to change a data field to short text and not long text when you are exporting to access


    Thanks in advance

    Nadine

    ------------------------------
    Nadine Ryan
    Team Owner
    Easi Solutions
    Tuam
    00353872504753
    ------------------------------"

    Thanks Chris I tried that but its still coming out as long

     



    -------------------------------------------
    Original Message:
    Sent: 9/3/2020 10:16:00 AM
    From: Chris Porthouse
    Subject: RE: Txt type

    Steve is correct that the only thing you have control over are the data types (Character, Memo, Numeric, Date/Time).  I did do a quick test in Monarch Classic (v16 aka v2020) and if the data type is set to Character, it will export as Short Text.  Memo fields export as Long Text.

    ------------------------------
    Chris Porthouse
    Senior Professional Services Consultant
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-03-2020 04:43 AM
    From: Nadine Ryan
    Subject: Txt type

    Hi Guys,

    Is there a way to change a data field to short text and not long text when you are exporting to access


    Thanks in advance

    Nadine

    ------------------------------
    Nadine Ryan
    Team Owner
    Easi Solutions
    Tuam
    00353872504753
    ------------------------------
    "
  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited September 2020
    Nadine said:

    Thanks Chris I tried that but its still coming out as long

     



    -------------------------------------------
    Original Message:
    Sent: 9/3/2020 10:16:00 AM
    From: Chris Porthouse
    Subject: RE: Txt type

    Steve is correct that the only thing you have control over are the data types (Character, Memo, Numeric, Date/Time).  I did do a quick test in Monarch Classic (v16 aka v2020) and if the data type is set to Character, it will export as Short Text.  Memo fields export as Long Text.

    ------------------------------
    Chris Porthouse
    Senior Professional Services Consultant
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-03-2020 04:43 AM
    From: Nadine Ryan
    Subject: Txt type

    Hi Guys,

    Is there a way to change a data field to short text and not long text when you are exporting to access


    Thanks in advance

    Nadine

    ------------------------------
    Nadine Ryan
    Team Owner
    Easi Solutions
    Tuam
    00353872504753
    ------------------------------
    "
    This post was removed"
  • Mahmoud
    Mahmoud
    Altair Employee
    edited September 2020
    Steve Caiels_21881 said:

    Hi Nadine,

    Unfortunately not.  The only control you have is with the field types in the Classic or DPS table (Memo, Text, Numeric, Date/Time)

    What problems is it causing? Maybe there is a way around it.

    Regards,
    Steve.




    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-03-2020 04:43 AM
    From: Nadine Ryan
    Subject: Txt type

    Hi Guys,

    Is there a way to change a data field to short text and not long text when you are exporting to access


    Thanks in advance

    Nadine

    ------------------------------
    Nadine Ryan
    Team Owner
    Easi Solutions
    Tuam
    00353872504753
    ------------------------------
    "

    Hi Nadine,
    The only way I was able to export character fields as short text to an MS Access table was:
    I created the table schema in Access table
    I exported a table from DPS with Append, and Append
    image


    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Altair Engineering
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 09-03-2020 08:32 AM
    From: Steve Caiels
    Subject: Txt type

    Hi Nadine,

    Unfortunately not.  The only control you have is with the field types in the Classic or DPS table (Memo, Text, Numeric, Date/Time)

    What problems is it causing? Maybe there is a way around it.

    Regards,
    Steve.




    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------

    Original Message:
    Sent: 09-03-2020 04:43 AM
    From: Nadine Ryan
    Subject: Txt type

    Hi Guys,

    Is there a way to change a data field to short text and not long text when you are exporting to access


    Thanks in advance

    Nadine

    ------------------------------
    Nadine Ryan
    Team Owner
    Easi Solutions
    Tuam
    00353872504753
    ------------------------------
    "

Categories