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.
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "tblIn_Pdf_not_in_Master", InpdfNotInMastFile, True, "A1:D150"
And I tryed this:
Code:
DoCmd.OutputTo acOutputTable, "tblIn_Pdf_not_in_Master", acFormatXLS, InpdfNotInMastFile
Any Ideas would be a reeall help.
Thank you