Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
import excel from specific tabs
- Thread starter ali32j
- Start date
Create a linked table to your spreadsheet tab (or a named range).
On the tables tab, use New -> Link Table -> select Microsoft Excel file format -> point it at your spreadsheet -> then select your named range or tab as appropriate.
Follow the wizard through to completion, then you can then treat the data as a table in Access.
John
On the tables tab, use New -> Link Table -> select Microsoft Excel file format -> point it at your spreadsheet -> then select your named range or tab as appropriate.
Follow the wizard through to completion, then you can then treat the data as a table in Access.
John
- Status
Similar threads
