SQL / Excel question

[BigV]

In the interest of completeness, I haven't gotten to the DTS/export stage. I hope I don't have to export it at all.

I intend to use the DTS package to scan the Excel file and extract portions of rows where the date meets some as yet undefined criterion. Once I have that subset of rows in the temporary table in SQL, I need to send an email to some users. In that email, I want the \\server\directory\filename to appear. =GetAddress() displayed that text in another cell in the same row in the Excel file. I reckon I can pick that up in the DTS package.

One problem =GetAddress() revealed was the sloppy condition of the data in the linklocation part of the cell. I have...inconsistent representations of the locations and names of the files. Specifically, spaces and %20 are freely interchanged. =GetAddress() chokes on the first %20, displaying only what follows the %20, ignoring the leading part (where the server directory and partial filename exist).

I set the owner of the file on the task of normalizing the filenames. We'll see next week how things are looking up.

Thanks to all for your help and interest.