Topic: openrowset and dbf. The file name contains the forbidden characters or too long
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4042.0 (X64) Mar 26 2015 9:18:04 PM Copyright (c) Standard Edition Microsoft Corporation (64-bit) on Windows NT 6.2 <X64> (Build 9200:) (Hypervisor)
select * from openrowset ( ' Microsoft. ACE.OLEDB.12.0' ,' dBASE IV; Database = \\Path' ,' select * from "71190917 (1).DBF"' )
The supplier of an OLE DB "Microsoft. ACE.OLEDB.12.0" for a linked server "(null)" returned the message "'" 71190917 (1).DBF "' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.".
The message 7321, level 16, state 2, line 1
Error by request preparation "select * from" 71190917 (1).DBF "" to performance by means of the supplier of an OLE DB "Microsoft. ACE.OLEDB.12.0" for a linked server "(null)".
To rename a file hands I is finite I can, and in this case errors will not be. But each time to correct not a variant.
Whether it is possible to overcome somehow this error without file renaming?
THE ITEM WITH.
At usage of square brackets: select * from [71190917 (1).DBF] produces an error about absence of a file 71190917 .DBF