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