Can I force datatypes with ADO?

dweeb

I have several PostGreSQL views linked into an Access database.

My queries require several joins.

The original views have data types of 'memo' in the fields that I need to join.

What I've done is make a create-table query which mimics the linked table. I then have to manually open the newly-created table and change the data type fields from memo to text in order for my queries to run.

My question:

Is there a way to programmatically (either ADO or VB) force the data types on the created tables from memo to text?

Thanks in advance for all of your help.