Creating Access Database

  johnincrete 07:41 03 Jun 2009
Locked

I have a folder containing songs (all legally owned!!) The file names are the song title or first line.
Can I create an Access database and import the file names, one per record to save me having to type them in?

  Crunchy 14:39 03 Jun 2009

At the dos prompt make your directory the current directory, then enter dir>>files.txt
This creates files.txt in the same directory. Open in excel and edit the rows. Save as excel file then import into your Access database.

  johnincrete 06:42 04 Jun 2009

Thanks for the info and for getting back so quickly.
Actually, I think I may just use the Excell spreadsheet - it will be just as good as Access

  johnincrete 17:47 04 Jun 2009

How do I get to the Dps prompt & how do I make L:\christian music to be my current directory.

I know it will be easy but it is very difficult when you don't know how!!!

  jaraba 19:24 22 Dec 2009

All programs
Command Prompt

In the command prompt where the flashing minus sign is type cd L:\christian music and then press enter.
you may have to enclose the christian music part in "".

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone