Mitsules, Mark
Mark.Mitsules at ngc.com
Thu Dec 2 10:46:15 CST 2004
Paul, Do you have access to the 97 ADH? I believe there were several class modules that could handle your situation. I use: Line class from Chapter 5 Lines class from Chapter 5 TextFile class from Chapter 5 Mark -----Original Message----- From: Paul Hartland (ISHARP) [mailto:paul.hartland at isharp.co.uk] Sent: Thursday, December 02, 2004 11:08 AM To: accessd at databaseadvisors.com Subject: [AccessD] Importing Multiple Text Files From Specified Folder To all, I have a folder with around 100+ text files thaht I need to import into a single table in an access database, is there anyway I can loop through all files with a .txt extension and automatically import them one by one into my table.... Thanks in advance for any help, suggesstions & sample code etc PAUL HARTLAND Database Designer/Programmer paul.hartland at isharp.co.uk ISHARP DDI - 01922 472031 Mobile - 07730 523179 ISHARP (Information Services for Hospitality, Audit, Retail and Pharmacy) provide IT resources for the Christie Group Stock & Inventory Services companies. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com