Reading Directory Info Into Access Tables

[Frank M. Bland via AccessMonster.com]

My knowledge of Access is limited to manipulating tables, queries, forms,
reports and macros and I have virtually no familiarity with more advanced
uses.

I need to collect file data from CDs (filename, size, modified date, etc.)
and store this information in tables for manipulation at a later date. Can
someone help me out with this?

Frank

 

[Guest]

Use a DOS command by clicking on Windows START - Run and enter CMD then OK.

Type Help DIR and enter to view your choices of data to extract.

Type the drive letter followed by a colon where the CD is at - press enter.

Type DIR then enter to see the file data. Use the switches such as /s that
lets you include subdirectory information - You learned all about the
switches when you entered Help DIR.

To save that informatio to file end you command line (DIR/s /b ) with

C:\MyCDFile.txt

This saves the information to that file on your c:\drive.

Hopes this help you.

 

[Frank M. Bland via AccessMonster.com]

Thanks for your help. Now all I have to do is figure out how to parse this
file and insert the data into a table. With a little tinkering I should be
able to figure it out.

Frank

Use a DOS command by clicking on Windows START - Run and enter CMD then OK.

Type Help DIR and enter to view your choices of data to extract.

Type the drive letter followed by a colon where the CD is at - press enter.

Type DIR then enter to see the file data. Use the switches such as /s that
lets you include subdirectory information - You learned all about the
switches when you entered Help DIR.

To save that informatio to file end you command line (DIR/s /b ) with

C:\MyCDFile.txt

This saves the information to that file on your c:\drive.

Hopes this help you.

My knowledge of Access is limited to manipulating tables, queries, forms,
reports and macros and I have virtually no familiarity with more advanced

[quoted text clipped - 5 lines]

Frank

 

[Ed Warren]

Try going through Excel to Access:

Open the *.text file in Excel, convert text to columns, make sure it has
properly parsed the text, add the column names you want, then save it as an
excel spreadsheet, then import the excel file into access

This normally works for me.

Ed Warren

Thanks for your help. Now all I have to do is figure out how to parse this
file and insert the data into a table. With a little tinkering I should be
able to figure it out.

Frank

Use a DOS command by clicking on Windows START - Run and enter CMD then
OK.

Type Help DIR and enter to view your choices of data to extract.

Type the drive letter followed by a colon where the CD is at - press
enter.

Type DIR then enter to see the file data. Use the switches such as /s
that
lets you include subdirectory information - You learned all about the
switches when you entered Help DIR.

To save that informatio to file end you command line (DIR/s /b ) with

C:\MyCDFile.txt

This saves the information to that file on your c:\drive.

Hopes this help you.

My knowledge of Access is limited to manipulating tables, queries,
forms,
reports and macros and I have virtually no familiarity with more
advanced

[quoted text clipped - 5 lines]

Frank