import excel to access

  • Thread starter Thread starter raymond chiu
  • Start date Start date
R

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
 
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.
 
Hi Raymond

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

Cheers
JulieD
 
Back
Top