ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking access and excel (https://www.excelbanter.com/excel-discussion-misc-queries/164791-linking-access-excel.html)

LINDA

Linking access and excel
 
When I imported data from my excel file to my access table, the dates are
showing dates but some strange numbers dispite the fact that I specified the
field as time and date. Can somebody help? Furthermore, the data in the
excel file will get up dates every day and need to update the table in the
access as well. Can I use the link function? How can I do that? I picked
the link and saw the file appear in access. But I do not know how to merge
the excel data to the access table. I truly appreciate it if somebody can
show me how.

Thank you,
Linda


All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com