You say :"but the issue is that I need to retain the original metadata for the table". Please describe what you mean by original metadata. I ask because typically "metadata" describes things not in the values of variables such as time of data collection, instruments used, source of the file (organization) and other "stuff" that describes the data. As such, there is no way I would expect Proc Import to retain any metadata.     ... View more

It is usually much easier to debug issues without macro code.  So you don't have the complication of not knowing exactly what code is being run.   Can you create the same error without any macro code.  For example if you turn MPRINT on and then copy the code the macro generated into a new program and just run that code does it still produce the error? ... View more