DBF file name is truncated to 8 characters


Recently a customer raised a case to us. They need to import a lot of DBF files into SQL SERVER. But they found when DBF fine name is longer than 8 characters they received below error:

SELECT  * FROM OPENROWSET (‘MICROSOFT.ACE.OLEDB.12.0′,’dBase 5.0;HDR=YES;DATABASE=F:temp’,
‘SELECT * FROM SJSMX00103.DBF’)

 

OLE DB provider « MICROSOFT.ACE.OLEDB.12.0 » for linked server « (null) » returned message « The Microsoft Access database engine could not find the object ‘SJSMX00103.DBF’. Make sure the object exists and that you spell its name and the path name correctly. If ‘SJSMX00103.DBF’ is not a local object, check your network connection or contact the server administrator. ».
Msg 7350,