[AccessD] TransferSpreadsheet

Hey All
Is there a way to fire the DoCmd.TransfreSpreadsheet AcImport  in the 
front end but have the results stored in a table on the backend, I think 
I am just missing something.  Because the worksheet contains common data 
but column numbers  may  vary among worksheets, I need to delete the old 
table and create a new table each.time and handle the columns data 
through code.

Thanks