Import exvel spreadsheet using a saved import specification

[dubbdan]

Hi forum

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

Please Login or Register  to view this content.

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

[alansidman]

Look at this link

http://social.msdn.microsoft.com/For...-from-vba-code