Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Office

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-17-2005, 09:11 PM
nrg nrg is offline
Novice
 
Join Date: Jun 2005
Posts: 4
nrg is on a distinguished road
Question Can Access access folders & sub-folders and dig out data?


Is there a way? If so, what kind of data can Access access and can it then populate a table? If so, can the table be automatically updated? If so, can the update be triggered by time lapse, data augmentation, or by something else? If so, how does one set about it?

It looks like a tricky proposition to me.
Reply With Quote
  #2  
Old 06-20-2005, 01:08 AM
Novice
 
Join Date: Apr 2005
Posts: 12
volcane is on a distinguished road
Default

not very clear on what you want to achieve, but you can do this using Access import data function from the File->Get External Data->Import. If you know VBScript you can program it to automatically import based on schedule.
Reply With Quote
  #3  
Old 06-20-2005, 03:53 AM
nrg nrg is offline
Novice
 
Join Date: Jun 2005
Posts: 4
nrg is on a distinguished road
Default Spadework

I would like Access to be able to look up folders, dig out any data from the individual files in that folder, whether text, image, or whatever, see if there are any sub-folders associated with said folder, and dig out the data from the files therein, whatever it is.

Isn't the command "get external data" limited to data in a selected few common options, like text files, Word, Excel, etc?
Reply With Quote
  #4  
Old 06-20-2005, 10:45 PM
Novice
 
Join Date: Apr 2005
Posts: 12
volcane is on a distinguished road
Default

I haven't try this is in Access but I am sure you can do it using the FileSystemObject in Microsoft Scripting Runtime library
Reply With Quote
  #5  
Old 06-20-2005, 11:09 PM
nrg nrg is offline
Novice
 
Join Date: Jun 2005
Posts: 4
nrg is on a distinguished road
Default

Thanks Volcane. I'll look up SystemFileObject. Hope I can understand it!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate Folders 1dannyg2 Outlook 0 09-13-2008 11:10 PM
Outlook File Folders Deano2108 Outlook 0 09-01-2008 03:25 AM
Multiple Folders in Outlook Cabbage1031 Outlook 0 05-23-2007 10:56 AM
Personal Folders first? kian1977 Outlook 0 09-25-2006 03:02 PM
Folders from inbox Gone!!!!! abdullah Outlook 1 11-23-2005 05:18 AM


All times are GMT -7. The time now is 07:28 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft