DTS Package to Change Object Owner for Excel Import

[Cheryl3D]

Hi:

I have a development project where I'm using an Microsoft Access (ADP) Project file front-end and SQL Server 2000 backend. Users are logged on via the Windows NT authentication. I import a file into SQL Server via a function within a module using as part of the code:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97...

I need for the imported spreadsheet that becomes a table in SQL Server to automatically set the object owner as 'dbo' instead of the current username (who is performing the import).

Can I use a DTS package to get this done? If so, please explain how.

Thanks,
Cheryl3D