Copy data from Excel to Access

[dan-dre]

Hi,

I have an Excel sheet which I want to copy the content of and paste into a Access table. I can achieve this by literally copying the data in Excel, then moving to Access and pasting it in.

Can anyone suggest a nicely automated way of achieving this with a macro?

You thoughts are very very appreciated!

Thanks,

Dan

 

[skwilliams]

Have you tried the import or link external data under the File menu? I can import or link MS Excel files.

 

[dan-dre]

Thanks for your reply; that was one possible technique which wasn't quite right for this task. I have literally just figured it out tho: for anyone else, here 'tis:

DoCmd.TransferSpreadsheet acImport, 8, "sampletable", "sourcefile.xls", True, "a1:d5"

where a1:d5 is the range.


Thanks all who looked at this one; especially to skwilliams for the response


Dan

 

[skwilliams]

Sounds like your on the right track.

Good Luck.