Import from an excel sheet

H

Hesham Sakr

How could I have a control on a form that would import data from an excel
sheet and add records to the table represented by this form in access 2007?
and how to have a control for export as well to an excel sheet?

i need help ASAP.
 
H

Hesham Sakr

for got to say something, I dont want to import using the get external data,
i need to put a button on the form to do this!!
 
D

Douglas J. Steele

Look at the TransferSpreadsheet method. It does programatically what Get
External Data does manually.
 
Top