Change Access field type from number to text in VBA.
I have imported an excel file into access. One field is being read as numeric if the user entered only numbers into that column, but in fact in the Access application it is a text field. When I try to join the imported table field (imported as "number") to the related field ("Text") it of course does not work. How can I programatically change the field type from number to text after I import the table and before I need to join it to related tables? Thank you!
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!