Excel 2007 = Export Format

[access2010]

We are using Ms Access 2003 for our accounting program

Our accountant wants to receive our reports in a Excel 2007 spread sheet

When we export or records from Access 2003 our accountant receives our information as a Dot.XLS extension which they can not manipulate.

Can I please receive a suggestion on how to have our files exported in a Excel 2007 format

Thank you
Nicole

 

[Uncle Gizmo]

oBook.SaveAs "C:\Book1.xlsx"

See this Thread:-

http://www.access-programmers.co.uk/forums/showthread.php?t=127596

 

[Trevor G]

We are using Ms Access 2003 for our accounting program

Our accountant wants to receive our reports in a Excel 2007 spread sheet

When we export or records from Access 2003 our accountant receives our information as a Dot.XLS extension which they can not manipulate.

Can I please receive a suggestion on how to have our files exported in a Excel 2007 format

Thank you
Nicole

Hi Nicole what method are you using for your transfer? Do you have Office 2007 on your machine?