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
|