trying to export table data tpo Excel

[itm]

Hi,
This is really crazy but I have been trying to export, in MS Access 2007, data from a table to Excel. and it will not go for anything.
it does not error it just does not go. Now I have used the following in other versions Access for years but not ion 2007, so I do not know.
I have tryed these two techniqes:

Where InpdfNotInMastFile holds the path where I want it to go.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "tblIn_Pdf_not_in_Master", InpdfNotInMastFile, True, "A1:D150"

And I tryed this:

  DoCmd.OutputTo acOutputTable, "tblIn_Pdf_not_in_Master", acFormatXLS, InpdfNotInMastFile

Any Ideas would be a reeall help.


Thank you

[alansidman]

What version of Excel are you using? If you are using Excel 2007, then you need to change this in your line of code

 acSpreadsheetTypeExcel7,


to 
10,

Here is background

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[itm]

Thanks it now works Thank you