With 64 bit SQL 2008 on Server 2008 I read .dbf table with a long file name using:

SELECT *
FROM OPENROWSET(
'Microsoft.ACE.OLEDB.12.0'
,'dbase IV;Database=D:\WebTest\ShapeFiles'
,'SELECT * FROM [sppobs~4]')

because I get an error

"The Microsoft Access database engine could not find the object ...

when I use the entire name in the FROM clause.  Is there a syntax allowing me to specify a table name longer than 8 character length?

Hi abjones3,

Please make sure you have installed Microsoft OLE DB Provider for Visual FoxPro and try the following commands:

SELECT * FROM OPENROWSET('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;
SourceDB=D:\WebTest\ShapeFiles;
SourceType=DBF',
'SELECT * FROM [sppobs~4]')

For more detail information, you can refer to the following link:

Microsoft OLE DB Provider for Visual FoxPro 9.0
http://www.microsoft.com/en-us/download/details.aspx?id=14839

How to import a DBF file in SQL Server
http://stackoverflow.com/questions/52822/how-to-import-a-dbf-file-in-sql-server

Trouble importing .dbf file into SQL server 2008 express edition
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0abcaf7c-6df6-49ce-868d-afbede249cff/trouble-importing-dbf-file-into-sql-server-2008-express-edition