So i was following this example from https://blogs.msdn.microsoft.com/samlester/2018/02/23/importing-a-dbf-file-into-power-bi/
since i have a DBF database i want to import and am getting this error message.
DataSource.Error: OLE DB: Could not find installable ISAM.
DataSourcePath=data source="C:\Users\akwang\Desktop\RMA File\";extended properties='dBASE IV", [Query="select * from [RMA.DBF]';provider=Microsoft.ACE.OLEDB.12.0
Message=Could not find installable ISAM.
Any Idea how to solve? i have a 64bit install of office.
It seems like you're use multiple extended properties in you connection string, right?
If this is a case, extended properties value tokens must be quoted.
If you use more than 1 extended property then the value tokens must be quoted, otherwise there is no way for the driver to distinguish them from the other non-extended properties in the connection string.
my code is:
Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12;Data Source=C:\Users\akwang\Desktop\RMA File\;Extended Properties=dBASE IV"", [Query=""select * from [rain.dbf]")
This is exactly as stated in the blog. I followed the link you posted and tried different mods to the string such as
Extended Properties=dBASE IV;HDR=Yes""
Extended Properties='dBASE IV;HDR=Yes'"
And i get syntax ERROR.
It seems like your issue is not caused with extended properties, maybe you can take a look at following official document to fix registry of dBase.
If above not help, you can also try to contact to author for know more about that operations.
Notice: please do backup before operate if you want to modify registry.