VBA Commands To Import DBF Files Into A New Table

[wycliffslim]

I've been creating an automated way for users to import an existing DBF III file into an Access Table and then I'll be doing some other things after it's in. The user needs to be able to click a command button to open up a file picker, select the desired DBF and then click import and have it be imported into a new table.



Originally I had this all working because there was only one possible file name for the DBF file in each folder so instead of using a file picker I used a folder picker and supplied the file name in the VBA code as it was static.

However, I now need the user to be able to select a specific file and the name could be anything.

I've successfully edited the file picker to allow them to select a file however the importing is an issue. In order to do a TransferDatabase command I need the file path alone for DatabaseName and the file name alone for Source.

What would be the best way to split those two pieces of data up once the user has selected the file they need?

Thanks in advance for any help.

[ssanfu]

Once you have the full path and filename from the file picker, use InStrRev() to get the position of the last "\", then use the Left() and Right() functions to get only the path and the only the filename.