Import data from more than one range

[JulieS]

I am trying to import data from an excel spread sheet into Access. The problem is that the data is in more than one range. So in my macro, I have:

sheet1!A1:J3

but I do not know the syntax to say:

sheet1!A1:B3, sheet1!E4:F7

(the error message when i type in the above syntax is:
"the object 'sheet1$A1:B3, sheet1$E4:F7' cannot be found".

Thank you for your help,
Julie