transferring data into access from excel

[SteveCarrier]

Hello

This is a very generic post but I was wondering if anyone had experience with transferring data from excel into access. I know that it can be done from the VBA code by referencing the different cells but maybe there is some resources to follow on a web site.

Thanks in advance.

Steve Carrier

 

[alibongo]

Here is one way to do it I have used before sorry dont know any other web resources.

DoCmd.TransferSpreadsheet acImport, AcSpreadsheetType9, "tblTest", strFullName, True, strRange

You can also specific cells to import through strRange.

Hope this is of some use