Import from Sage Line 50

[jackmac]

Hi all,

I'm trying to pull data from Sage Line 50. I want to get the customer name, contact details and account number. They sem to be in the Sales_Ledger table in Sage but when I go to open them in Filemaker 11, it doesn't show any fields as being available. Anybody any ideas?

If I use Excel for the import I can get some of the info out using the Sales_Ledger table but Filemaker shows it as having no fields.... confused!