I have added sqlexpress with my sql 64 bit in windows xp so i could use oledb to access excel files. I can not use ace as the excel is 2003 and not all 64 bit. It works perfectly until i try and run exec stored proc (has my oledb procedure) to
insert the results into a table variable.
the excel test procedure works fine by itself but as soon as i use insert it crashes. any ideas??
View Complete Post