05-13-2014 12:37 AM
I am doing a project with two function:
1.exporting an excel file with data in accessdatabase(.mdb file) file
2.importing an excel file to update the data in the access database(.mdb file)
now I have done the first one.
I have no idea with the second one, I can only popup an file select window and select an specified excel file ,than get the filepatch and name ,but I don't know what to do else...
Is anyone good at this?Thank you very much.
I use CVI9.0 and sql toolkit 2.1 ,access 2003.
05-13-2014 01:53 AM
To read/write data to Excel files CVI offers two instruments: excel2000.fp and excelreport.fp; both are located in <cvidir>\toolslib\activex\excel
The first one is the basic framework with functons to read/write data, call macros and generate graphs, while the latter is built on top of the first one and is aimed to design and populate technical reports on tests.
In <cviSamplesDir>\activex\excel you can find some examples on how to use those instruments; some material can be found on the forums as well since several users have posted questions on this subject.