Import exvel spreadsheet using a saved import specification

Hi forum

I am trying to import an excel table into access using a saved import specification.

 
DoCmd.TransferSpreadsheet acImport, "IMPORT_COORDINATE_FILE", Forms!ADD_ADJUSTMENTS!TABLENAME, Forms!ADD_ADJUSTMENTS!Coordinate_Input_File, True, ""

I have been modeling my approach from the Transfer text method. The "import_coordinate_file" is the name of the import specification i wish to use. Is it possible? I want to use my specification because i have selected the primary key from the imported table.


Thanks,


dubbbdan