import excel to access

[raymond chiu]

Dear all,

I know how to export the query data to excel using file dialog.
How can I do to import the excel file "excelfile.xls" of "sheet1" to access
file "Accessfile.mdb" of "Table1"?

Please help!

Raymond

 

[Bob]

You can use Get External Data from the File menu to pull
Excel data into Access. The wizard will ask for the Excel
sheet number among other things. You will be given the
choice to import to a new table or an existing table.

 

[JulieD]

Hi Raymond

have you tried
file / get external data / import and followed the wizard?

Cheers
JulieD

 

[raymond chiu]

Hi,

I want automation using form object and textbox and command button.