Grahamn

"and contains macro's causing it to be a .xlsm file."

As you already use a macro why not save the file as a TAB separeted text file etc.txt

and use SSIS or T-SQL bulk insert to import the file.:-)

I never use SSIS to import natural Excel files.

Gosta M