First off let me say that I know that this is not a Access Forum .. but I have tried repeated to get my data into a Access table and it is not working.. So this is what I am hoping to accomplish in Excel... Since my knowledge of Excel far exceeds my knowledge of Access...

What I want to do is put a command button in Access that opens an Excel add-in spreadsheet. then it will at first prompt you to select a file to manipulate and then when the file is opened manipulate the spreadsheet the way that I want it to. So that I can import it into Access... Without having to do all the crazy calculations in an Access Query ...

Hopefully someone can help ....