ÆØÅ

There should be no problem exporting from Access to EXcel with
Danish characters.

How are you exporting?

Could you send an example of your data?

Hey!

Eksporten er lagt på en knap i Access med følgende kode og bliver
lagt over i Excel 2003

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

    Dim stDocName0, stDocName1 As String

    stDocName0 = "AlleFelterExcelEksport"
    stDocName1 = "AlleFaktExcelEksport"
   
    DoCmd.OutputTo acOutputQuery, stDocName0, acFormatXLS, "K:\Disp.xls", False
    DoCmd.OutputTo acOutputQuery, stDocName1, acFormatXLS, "K:\Fakt.xls", False
   
    DoCmd.SetWarnings 0
    DoCmd.OpenQuery "qry_AlleFelterExcelLog", acViewNormal, acAdd
    DoCmd.SetWarnings -1
   
      Dim xls As New Excel.Application
    xls.Visible = True
    xls.Workbooks.Open FileName:="K:\Rap.xls"

Exit_Command0_Click:
    Exit Sub

Err_Command0_Click:
    MsgBox Err.Description
    Resume Exit_Command0_Click
   
End Sub

"I forbindelse med, at jeg har fået lagt Vista og en ny Access 2007 / Excel 2007"

Isnt the problem in 2007?

From the code I can see two files get exported and they are not the same as the file whic gets opened in Excel ("K:\Rap.xls")

Can I see the dB?

"Disp" and "Fakt" are temporary files where "Rap" import parts from. The problem is in both versions (2003/2007) when exported from Access ??

Cant help without seeing the dB. As I mentioned there should be no problem with Danish characters unless maybe they have been entered in another system.

Can you send the dB?

If I change xls to xlsx file format (2007) so it works???

DoCmd.OutputTo acOutputQuery, stDocName0, acFormatXLS, "K:\Disp.xlsx", False
    DoCmd.OutputTo acOutputQuery, stDocName1, acFormatXLS, "K:\Fakt.xlsx", False


I think it is somewhere in vista......

If I change xls to xlsx file format (2007) so it works???

DoCmd.OutputTo acOutputQuery, stDocName0, acFormatXLSX, "K:\Disp.xlsx", False
    DoCmd.OutputTo acOutputQuery, stDocName1, acFormatXLSX, "K:\Fakt.xlsx", False


I think it is somewhere in vista......

Sounds like an error in Office 2007 to me.

I would have thought that the format type acFormatXLS would still work in 2007. This actually mean that code needs altering to be compatible.

In some cases it might be necessary to export to an older version of Excel, so why acFormatXLS doesnt work is strange.

If you need to export to a specific Excel version then you could consider using

DoCmd.TransferSpreadsheet ...

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,stDocName0, "K:\Disp.xls"


Although I'mm not at all sure it works as I would expect it to.

acSpreadsheetTypeExcel9 is Excel 2000 so an exension of .xls shoule be OK- but when I ty it, it says that its in a different format than that specified by the file extension. If I give .xlsx as the extension then its OK.

Very strange, as the fiel format should be controlled by acSpreadsheetTypeExcel9

Lukker