How can I convert the data type of a field within Toad Data Point in Access? (4275545)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How can I convert the data type of a field within Toad Data Point in Access?
Description

In Toad Data Point 3.2, there does not appear to be Alter Table feature in MS Access and Excel to change a datatype (like in an Oracle database.)
Resolution

Workaround:
Run the following query in the editor for MS Access.

ALTER TABLE table_name
ALTER COLUMN column_name datatype
Defect ID

IP

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title