Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sharing data between Excel and Access
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sharing data between Excel and Access
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 FileExternal 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 DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Linda" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sharing data between Excel and Access
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 "Nick Hodge" wrote: 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 FileExternal 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 DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Linda" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing an Excel Workbook and Remote Web Access | Excel Discussion (Misc queries) | |||
Data sharing | Excel Discussion (Misc queries) | |||
Sharing workbooks - user access | Excel Discussion (Misc queries) | |||
Sharing Data Between Worksheets | New Users to Excel | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) |