Importing file directory into database....
15 January 2003, 05:58 PM
#1
Scooby Regular
Thread Starter
Join Date: Jun 2000
Posts: 3,783
Likes: 0
Received 0 Likes
on
0 Posts
I need to move the filenames contained in a folder into a database. There's hundered of them. Anyone think of an easy way to do this ?
eg. Using MS Access, create a table called 'files' with a text field called 'filename' and somehow import them all into there ?
-Darren
eg. Using MS Access, create a table called 'files' with a text field called 'filename' and somehow import them all into there ?
-Darren
15 January 2003, 06:11 PM
#2
Scooby Regular
Join Date: Aug 2002
Posts: 154
Likes: 0
Received 0 Likes
on
0 Posts
dir /a:-d /b > textfile.txt
The /a:-d leaves out directories, /b leaves out the headers & footers.
If I wanted to do this regularly, I'd do something in Access Basic to load the table directly.
The /a:-d leaves out directories, /b leaves out the headers & footers.
If I wanted to do this regularly, I'd do something in Access Basic to load the table directly.
Thread
Thread Starter
Forum
Replies
Last Post