View Single Post
  #2   Report Post  
Posted to microsoft.public.access.macros,microsoft.public.excel,microsoft.public.excel.programming
Andy B[_3_] Andy B[_3_] is offline
external usenet poster
 
Posts: 3
Default Can I "Save As..." an Excel Sheet to an Access Table?

Hi

You can open an Excel sheet in Access. With that in mind, I would suggest
writing an append query in Access to add the details from the Excel sheet to
the existing table.

--
Andy.


"John Bixtis" wrote in message
...
Hi,

I want to "push" data from an Excel report to an Access database.

Do you know if there is a VBA script that saves an Excel sheet as an

Access
table?

Do you know if there is any other way to "push" data from an Excel report

to
an Access database.
The Excel report is different every day, the Access is the same and keeps
the history.


John