I'm trying to use date format reading data from ms access db.
I Always has errors but not so clear.
The problem is on date function but it seems that field are correct.
Is there syntax mistakes ?
// date("Data_Off", 'DD-MM-YYYY') As "Data_Off",
Month("Data_Off") As "Mese_Off",
Year("Data_Off") As "Anno_Off",
Day("Data_Off") As "Giorno_Off",
I'm used to put '_' (underscore) within field names but it seems that QS continue to read them as it was a " " blank space adding " " around the name of field .
Is it better to use [name_field] as in ms access ??
If I comment that three field I don't have any error....
This is the error but it's very cryptic...
date(Data_Off, 'DD-MM-YYYY') As Data_Off,
Month(Data_Off) As Mese_Off,
Year(Data_Off) As Anno_Off,
Day(Data_Off) As Giorno_Off
Why is there a path name in your MS-Access table specification?
In addition to that, you seem to experience two problems at the same time: one in the ODBC read, and one in the LOAD as you mentioned in the original post?