As part of an ADO Recordset, I would like to create an empty Field. I would
like to open the RecordSet (using an SQL statement) with data from an SQL
Server database, disconnect the Recordset, and then use the empty Field to
enter additional data. I can do all of this, but . . .

My question is - How do I assign this empty field a data type?

(I do not believe I can use the ".Fields.Append" method, since any existing
fields would be wiped out when I open the recordset with my SQL command. So,
I need to create this empty field and assign it a datatype in the same SQL
statement that I use to access data from the SQL Server database. I think.
Sigh.)

Thanks much!