Thanks for the replies.
I ended up using a Data Transformation Service to create a database and import the information from the Excel file.
I just schedule it to run once a day...
John
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me