P Payal Patel Registered User. Local time Today, 03:04 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, 06:04 Joined Mar 27, 2009 Messages 853 Nov 6, 2009 #2 use the docmd.transferspreadsheet command. Check the VBA Help for the correct syntax