Excel importing?

  • Thread starter Thread starter Brian M
  • Start date Start date
B

Brian M

Is there anyway to import an excel spreadsheet to the
database in access? I have a spreadsheet I have been
using and now I want to incorporate this into the
database. Thanks!
 
Brian said:
Is there anyway to import an excel spreadsheet to the
database in access? I have a spreadsheet I have been
using and now I want to incorporate this into the
database.


You can use the File - Import menu item to either copy the
data in to an Access table or link to it in the workbook. If
you want to do this programatically, use the
TransferSpreadsheet method. Check the details in Help.
 
Back
Top