See the second example in this article:

http://access.mvps.org/access/general/gen0008.htm

then once the data is in Access, you can do whatever... (Probably export back out... and go through SSIS as planned.)