Access to Excel Data Transfer When Language Isn't English

[grovelli]

Zipped file goes over the accepted size so I uploaded it here
On the startup form, select gennaio for start, ottobre for end, 2011 for year and then click the button labelled UtiImp.xls. The UtiImp.xls file gets created just fine if the language settings in Windows are English UK while if I select Italian, the numbers in the range c5..e20 in the Dati tab in the Excel file are mostly wrong. How can I solve this?

[HansV]

Your link appears to be to the Virgilio home page...
Sorry, it works now.

[HansV]

What are the correct values? And how can I check the values? Surely you don't expect us to dig through 144570 records to find out?

[grovelli]

Sorry Hans,
Eng.jpg is what I get if language is English and Ita.jpg when language is Italian

[HansV]

If you open the query qryExport on a system with Italian settings, does it return the correct values, or do they already look as in Ita.jpg?

[grovelli]

Hi Hans :-), it returns the correct values

[HansV]

What happens if you remove all instances of

& ""

from the following lines in ExcelExportDati:

Code: Select all

i = 5
    Do Until rst.EOF
        ws.Cells(i, 2) = rst!Impianto & ""
        'ws.Cells(i + 18, 2) = rst!Impianto & ""
        ws.Cells(i, 3) = rst!marc & ""
        ws.Cells(i, 4) = rst!Int & ""
        ws.Cells(i, 5) = rst!Disp & ""
        i = i + 1
        'fFound = False
        'For i = 5 To 20
        'If ws.Cells(i, 2) = rst!Impianto Then
        '    ws.Cells(i, 3) = rst!Totale & ""
        '    fFound = True
        '    Exit For
        'End If
        'Next i
        'If Not fFound Then MsgBox "Label " & rst!Impianto & " was not found!"

        rst.MoveNext
    Loop

[grovelli]

It works!
I forgot why I put the "" after the ampersand though

[Pat]

It works!
I forgot why I put the "" after the ampersand though

Maybe to make them text fields rather than numeric??

[grovelli]

Hi Pat , I'm not sure about that since, with English settings, keeping the quotes still produces numbers when numbers are passed to the Excel cells as do most of the numbers passed with Italian settings.

[Pat]

Fair enough, i know i have used them in the past, obviously under different circumstances.