how to save to Access  
Author Message
eijitek





PostPosted: Thu May 26 08:58:22 CDT 2005 Top

Excel Programming >> how to save to Access

Hi all,
need help on how to save cells values in excel sheet to microsoft access.
all help needed
regards

Excel195  
 
 
KDales





PostPosted: Thu May 26 08:58:22 CDT 2005 Top

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
>
>
>