Sharing data between Excel and Access

L

Linda

I have my original data in excel format. Can I convert the data in Excel to
Access as the data base in Access? I know how to export data from Access to
Excel, but do not know the reverse. Can somebody answer my question?

Thank you,
Linda
 
N

Nick Hodge

Linda

You can either Import it or Link the Excel table (the latter will always
have the up to date data from the Excel worksheet

In Access go to File>External data> and select import or link. (Be sure to
select Excel from the 'files of type' dropdown in the dialog)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
F

FSt1

hi
and to add to Nick's suggestion, make sure you declare you xl data a named
range. this make for a cleaner import/link. and as Nick pointed out, linking
give up to the minute data and it is a little silly to store the same data in
two different places.

Regards
FSt1
 
Top