P Payal Patel Registered User. Local time Today, 06:03 Joined Nov 3, 2009 Messages 34 Nov 6, 2009 #1 How do I import a a table into access from excel automatically using VB script? Thanks,
S Scooterbug Registered User. Local time Today, 09:03 Joined Mar 27, 2009 Messages 853 Nov 6, 2009 #2 use the docmd.transferspreadsheet command. Check the VBA Help for the correct syntax