View Full Version : importing excel worksheets into access


mani_singh
11-22-2007, 05:30 AM
hi!

i have a folder (C:\data) with a file in it (issues.xls)

i need a vba script of method that will make access import certain columns of the closed excel worksheets into the db.

any ideas

MStef
11-22-2007, 10:33 PM
Look at this address
http://www.access-programmers.co.uk/forums/showthread.php?t=135934