A atut New member Local time Today, 20:00 Joined May 25, 2012 Messages 3 Feb 12, 2014 #1 Kindly help me use VBA codes to inport records from Excel sheet to a table in Access. I have disabled all the ribbons, so I want to use command button to direct the import. Thanks
Kindly help me use VBA codes to inport records from Excel sheet to a table in Access. I have disabled all the ribbons, so I want to use command button to direct the import. Thanks
pr2-eugin Super Moderator Local time Today, 20:00 Joined Nov 30, 2011 Messages 8,487 Feb 12, 2014 #2 Simple method would be DoCmd.TransferSpreadsheet with acImport as argument.