Access file import in Diadem problems

[charlie92]

I can not import properly Access files into diadem. Sometimes it only imports field names with no records, sometimes it only imports some data messing all around. It's frustrating because in theory it should work completely automatic and I would really need it.
Access 2000 + Diadem 9.0.
I'm attaching a portion of test access file I cannot load properly
thank you for your help

[Walter_Rick]

Hi,

Find attached an example which works fine. I hope this will help you to solve the problem, because in general the import should work. In your MDB file you should not use spaces or special characters like & in table names or in channel names.

Greetings

Walter Rick

[Brad_Turpin]

Hi Charlie92,

Let me give a more detailed description of what is happening here. First of all, as Walter says, it's always a good idea to keep SQL column names as simple as possible. Microsoft can get around the traditional difficulties you encounter with fancy column names by keeping everything "in house" between say Excel and Access, but as soon as you start to use actual SQL commands from an external application, you run into problems. You have several columns in your database with either a space, an "&", a "�" or a "/" symbol in them-- all of these are problematic when creating and using SQL queries. I have renamed these columns and seen an immediate improvement in the values imported:

"chiller no"..............."chiller_no"
"downloaded data".........."downloaded_data"
"Date&Time"................"Date_Time"
"T_retn F�"................"T_retn_F"
"T_supl F�"................"T_supl_F"
"T_evap F�"................"T_evap_F"
"T_cin F�"................."T_cin_F"
"T_cout F�"................"T_cout_F"
"T_cond F�"................"T_cond_F"
"T_suct F�"................"T_suct_F"
"T_liq F�"................."T_liq_F"
"T_dis F�"................."T_dis_F"
"T_comp F�"................"T_comp_F"
"o/h"......................"o_h"
"T_retn C�"................"T_retn_C"
"T_supl C�"................"T_supl_C"
"T_evap C�"................"T_evap_C"
"T_cin C�"................."T_cin_C"
"T_cout C�"................"T_cout_C"
"T_cond C�"................"T_cond_C"
"T_suct C�"................"T_suct_C"
"T_liq C�"................"T_liq_C"
"T_dis C�"................"T_dis_C"
"T_comp C�"................"T_comp_C"

Secondly, the values in the "I" column appear to be different, but that is only because of the displayed rounding in that column-- if you make the column slightly wider you will see the values match.

I have attached an edited version of your database with the new column names described above.

Regards,
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[charlie92]

Hi Brad, I wasn't aware about these name problems.
Thank you very much for your help, now everything works fine.
ciao

Carlo Cerutti
Alstom transport
Birmingham GB