exchanging data between Excel and Access2003

[EastClaus]

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.

[RobertoBozzolo]

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.