How to import an Excel Spreadsheet

[krismcmillan]

Hi Guys

Can you please advise on how to import an excel spreadsheet into access 2010 which has got multiple merged cells on it?


The other way that I have found is, to remove the merged cells.

Also are you able to import three excel worksheets into the same access table?

 

[GinaWhipp]

Access cannot *translate* merged cells you would need to remove them, no way around that. And, yes, you can import as many worksheets as you into one table that is no problem.