» Welcome Guest
[ Log In :: Register ]

 

[ Track this topic :: Email this topic :: Print this topic ]

Topic: Making lists for 'Access' import< Next Oldest | Next Newest >
appleboy
Unregistered





Posted: Dec. 01 2004,01:46

Just a little thing.

When making lists, the length of a mp3 is written in the format of '5:25' as oppose to say '05:25' or even '00:05:25'.
When importing into Microsoft Access, any song lengths that are over 10:00 minutes, are not imported and show up as errors.  I thought altering the first mp3 length in the text file to the '05:25' format might have an effect on how Access registers the field, not so.

There is an option in Access to set the format of the 'Date/Time' field name data type to 'Long Time' which is '00:00:00'.  Maybe if the lists used this format, I would not  have any problems when importing the 'mp3 length field' into Access.

I realise this is a very small thing but it can't be that hard to modify and this is what I look to 'mp3/tag studio' for.  If I can't do something in another mp3 editing program, I know that there's the functionality and consideration king, who goes by the name of 'mp3/tag studio'.

cheers
Back to top
appleboy
Unregistered





Posted: Dec. 01 2004,01:48

p.s.

you can always just import the field as a 'text' data type . . .

. . . but . . . that's not the point . . .
Back to top
Magnus Brading
Almighty Author



Group: Super Administrators
Posts: 2751
Joined: Aug. 2002
Posted: Dec. 01 2004,02:36

I will try to make an option for it in a future update, thanks for the info.

--------------
Software author and website owner
Back to top
Profile PM WEB 
2 replies since Dec. 01 2004,01:46 < Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]