Importing files into Access 2000

[Haldane]

I have written a small access database that imports a file into a table, converts it and then exports it to a csv file so it can be imported into another program.
I need to be able to import about 5000 files each with a different extension into access (1 at a time)

Is there any way I can add a global command (ie .*) in the DisabledExtensions area in the registry?

Or is there a way I can rename the file before I import it into access through the use of a access macro?.

Brendon

 

[danvlas]

Use the Name statement to rename the file:

Name "C:\Path\OldName.ext" As "C:\Path\NewName.txe"

or make a copy of it to a specific folder:

FileCopy "C:\Path\OldName.ext", "C:\specificPath\NewName.txe"


Regards,

Dan