MapInfo Pro Developers User Group

How can I open all the tables one by one from a directory using Map Basic. There is a way where I can list all the path's in one text file and read it on run-time for opening the tables but is there any better ways to do that ?

You can find a number of MapBasic libraries/modules that can give you a list of files in a directory. Use one of these to get the list and then loop thru the list and do your task with the individual tables.

On Community Download you can find these libraries that can help you:

• MB Utils 1.0: http://communitydownloads.pbinsight.com/code-exchange/download/mb_utils-1.0-alpha
• File Folder and Drive Functions Library: http://communitydownloads.pbinsight.com/code-exchange/download/file-folder-and-drive-functions-library/
• MapBasic Common Libraries, look for FileLib: http://communitydownloads.pbinsight.com/code-exchange/download/mapbasic-common-libraries

The last one can be used like this:

nNumFiles = FILEFindFilesInFolder("C:\Temp", "*.tab")

For i = 1 To nNumFiles

sFile = FILEGetFindFilesFileName(i)

'**Do your work with the table

Next

Remember to copy the FILELib.dll to your application directory