View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LINDA LINDA is offline
external usenet poster
 
Posts: 205
Default 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