I am trying to create an active link table that uses an ADO datasource, is this possible?

I can create an import to get the data and can save the connection string but this does not appear to be available when trying to create a table link.

Any input would be much appreciated.