Export from Microsoft Access Database to Excel

[Sumithra_Nagappan]

Hai Team

 I have a task in which Test reports are entered in Microsoft Access.I'm familiar in entering data into Database, next part of the work is that,i should export particular part of the reports to Excel, say Sort data from one particular date to current date and Export it.Kindly help me out in this... 

[Yamaeda]

I'd say that's easiest done through excel or access, you can export a table as xls in access, and/or import via excel.

If you want to do it via LV i'd probably read the database and save a tab-separated textfile.

/Y 

[Sumithra_Nagappan]

How do i read and save it in Excel via LabVIEW???

[Yamaeda]

If you want to _control_ Excel you'll need to use ActiveX, if you want to write data in a form usable by Excel, see above.

/Y 

[Sumithra_Nagappan]

Hello Yamaeda

       I think you are not clear with my question.I need to sort/view particular data(for eg:Extract report from jan 2012 to feb 2012) in my Access Database and export the same to an excel using LabVIEW.how do i group data in Database using LabVIEW.?

[smercurio_fc]

The best way to do this is with a specific SQL query that returns the data do you in the grouped format that you want. If Access does not support that level of T-SQL compatibility then you'd have to program it yourself in LabVIEW by reading the data in bulk, massaging it, and then exporting to a tab delimited file for Excel (unless you decide to use the Report Generation Toolkit or program it yourself using ActiveX).

[Yamaeda]

That's a sql-question, export/excel one.

select * from report where date  > 2012-01-01 and date < 2012-02-29 order by date

/Y 

[Sumithra_Nagappan]

Yes it is an sql question

Consider this as my condition need to fetch records collected in database on 16-4-2012 

Table name =TEST_REPORT

i have passed the following query

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, it displays the entire record from database. i have my vi along with this mail.

[Yamaeda]

Try the query in Access to verify it. Create query, sql mode, copy/paste and see that it works.

/Y 

[Sumithra_Nagappan]

Sorry,But i dont know how to create query in access