My users want to be able to use a Keyboard shortcut or have me add a button
on the toolbar that will allow them to do the following:

-I have a column of pri keys in column A of my spreadsheet,
-These pri keys have been imported from another source and have different
numbers of rows each time they are imported.
-From that column, they want it to hit a SQL Server DB that gets all the
other columns of information based on that pri key
-They do not want to upload the file to the server and they dont want to
manually go through DTS to do it themselves.

is there an easy way to get this done, such as a macro that loads up the
data to and then brings it back from SQL Server?