Excel Programming >> how to save to Access
If you can control this from Access rather than Excel it is easy: Use a
named range in Excel for the data that needs to go to Access (and be sure to
save the file before the next step). Then, using File... Get External Data
in Access, create a linked table and specify your Excel file; you can then
select the specific named data range and it will become a table in Access
that is automatically updated whenever the Excel file is resaved. If you
need to combine the Excel data with an existing Access table, just use your
linked table in an append or update query.
> Hi all,
> need help on how to save cells values in excel sheet to microsoft access.
> all help needed
> regards
>
>
>