Excel importing?

[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!

 

[Marshall Barton]

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.