Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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
------------------------------

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Steve_Caiels

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

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

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

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"

Mo Abdolrahim

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

------------------------------
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
------------------------------
"