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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking an Access tbl to an excel tbl
- Thread starter Nate16
- Start date
Access handles Excel tables directly, provded you set them up as linked tables. Create a new table, selct link table, select Access as the type and you'll be preompted through what you have to do.
Be aware that there are some anomalies, reagrding data type. Excel doesn't distinguish in precisely the same way as Access, but experiment to find what suits you.
Be aware that there are some anomalies, reagrding data type. Excel doesn't distinguish in precisely the same way as Access, but experiment to find what suits you.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question