@ Guessed: If you could kindly have a look at the files I've uploaded here and let me know where the problem is, I would be very grateful.

@Macropod: Many thanks for the macro. At this point, as it is only one table I need to bring in, I may just try to clear up whatever styles/settings discrepancies there are (with Guessed's help) and do it by hand. The links for explaining how to use macros are so lengthy, it is quite daunting especially when I just need to import one table. In the future some time I shall definitely try to learn how to use Macros.