Does anyone know how to read from a .DBF file that has a file name of over 8 characters? anything smaller than this works fine, but i get an error when trying to read from a file that has a name over 8 characters.
i don't have any .CDX files, there are only .DBF files.
the files load in perfectly if i shorten the filenames so i think the easiest way is to create a loop to loop through the directory, rename the file, load in then rename it back then move to the next file and do the same.
That's one way of doing it but it could be slow if the files are large.
If you query the directory using DIR /X, you get the 8.3 shortnames alongside the long names so it should just be a matter of outputting this to a file, something like "DIR /X {directory} > myfile.txt", then parsing that file to create a mapping table. Or this might be useful on a file by file basis ...
I think I have a solution. The method is to check the length of the filename and if over 12 (8chars + .DBF), then go and get the shortname using a macro function (Current Local Security needs to be Allow System Access).
Macro function:
function GetShortName (file)
set fso = CreateObject("Scripting.FileSystemObject")
This example is loading variously named files with same data structure into one table AND logging errors to a log table. No renaming of files required.
