Export from Microsoft Access Database to Excel

[smercurio_fc]

Then read the Help file for MS Access. It tells you how to do it.

[Yamaeda]

[Sumithra_Nagappan]

hai yamaeda

  i tried by pasting my query in access and came out with few more doubts

SELECT Serial_Number,System_Date,System_Time,Department,Operator_Name,Serial_Number,Test_Case,Pass_Fail FROM TEST_REPORT  where System_Date = "4-16-2012"; 

when i pass the above query directly in access i could exactly what i need but an error in labview stating that it contains invalid string. " ; are the invalid strings i guess,is there any way to pass them? 

[Sumithra_Nagappan · Accepted solution]

Hai

I fixed the issue with htis link https://decibel.ni.com/content/docs/DOC-10091. Use of sql statement generated ,it is easy to fetch/sort data as per our requirement.