How can I copy-paste / import excel table to access table?

[benzo1]

Hi, I have formatted an excel file so that the cell rows and columns should all fit perfectly into an access table.

How can I copy and paste the data from excel to the access table?

I am having a lot of difficulty doing this, so any advice would be greatly appreciated.

Thanks.

Benzo1

 

[KenReay]

Hi

Make the 'table' area a named range in Excel

Use File \ Get External Data \ Import to import the data

You can also do the import in code, using docmd.transferspreadsheet Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK