Import dbf file.

Hello guys. I have to import dbf files in NAV 5.0. There is no problem with files with name length 8 characters or less. But I can’t import files with length more than 8 characters. Is there any possibillity to do this? I can rename files but it’s not good solution.

I’ve never run into a problem with file name lengths in NAV. How are you importing the file? What error/issue is it having with the file names longer than 8 characters?

This is the code that i use to open file:
ConnStr := ‘Provider=Microsoft.Jet.OLEDB.4.0;Data Source=’ + FPath + ‘;’ +
‘Extended Properties=dBase IV; mode=Read|Write|Share Deny None;’ +
‘Locale Identifier=1058;’;
ADORecSet.ActiveConnection := ADOConn;

IF the length of Filename > 8 i have the error

Microsoft Dynamics NAV

This message is for C/AL programmers:

The call to member Open failed. Microsoft JET Database Engine returned the following message:
Invalid SQL statement; expected ‘DELETE’, ‘INSERT’, ‘PROCEDURE’, ‘SELECT’, or ‘UPDATE’.


I’ve done some searching and this is a known problem. For example:

As you’ve already figured out you will need to find a way to get the 8.3 name for the file. It could be as simple as changing “MyLongFileName.dbf” to “MyLong~1.dbf”. The only problem would be if the first 8 characters of the file name don’t uniquely identify the file. Then you run into the “MyLong~2.dbf” or “MyLong~3.dbf” problem.

I’m looking around to see if I can find a easy way to do that, but you should too.

Thank you for reply. I read this post, but i supposed that there is solution more elegant than file renaming.