How to import Excel spreadsheet data to MS Access DB

[qd]

I want to transfer the data from Excel spreadsheet to MS Access by Labview. Everyday we save our test data into Excel spreadsheet and then we need to transfer those data into our MS Access database. Anyone can help me with an example code for this?

Thanks.

[Philip_Courtois]

Hi qd,

Congratulations with your first post to the forum! Please make sure that you post your questions to the right product forum - the question you are asking is more suitable in the LabVIEW forum than here in the Instrument Control forum.

Even if someone gave you an example of how to extract data from an Excel spreadsheet and write the data to a database, it would almost certainly not fit your need. There are simply too many factors that you have to decide for yourself: What is the data and how is it stored in the Excel file and how do you want it stored in the database? What is the file format of the Excel file and how did you originally store it (with the Report Generation Toolkit)?

I would recommend you to use the shipping examples that cover both reading an Excel file (with the Report Generation Toolkit) and wirting data to a database (Database Connectivity Toolkit) to get started. Then, if you are having issues with your code, please submit your question again specific to what the issue is, thanks.