How to link excel.xlsb with a table?

[cos]

How do i link an excel document in .xlsb format to a table so that i can enable aumtic update (i.e. when a new record is entered in the excel document, i see it in my table in access)?

I know that there is a standart method of linking normal excel with access, but it doesn't seem to like .xlsb format :banghead:

p.s. i use Office 2010

 

[Pat Hartman]

Why is the workbook in binary format? I haven't tried to link any workbooks in that format so I don't know that it is or isn't possible. Generally you would use the TransferSpreadsheet to import or link to workbooks.