import from Microsoft Access database?

Share icon

Is anyone in the Igor community aware of an XOP or procedure to import data from a Microsoft Access database?

I'm working with a couple of instruments that output data to this format, and would love to skip the import to Excel before digging into the data in Igor. I did a search on "Microsoft Access," "Access," "Microsoft," and "database," and didn't find any results in the top hits that seemed relevant.

It seems straightforward to extract access to Excel using VBA, and I'm sure that I could eventually figure it out, but if anyone has advice or tips about how to get started, I'd love to avoid re-creating someone else's work.

Thanks in advance for your help!
I believe that MS Access supports ODBC, and therefore you should be able to use the SQL XOP that ships with Igor. For more information, execute:
DisplayHelpTopic "SQL XOP"

April 21, 2015 at 07:23 am - Permalink