What I am trying to do is to copy certain tab [spreadsheet] and Paste Append
onto Access. Therefore, neither importing nor linking will do it.
Thanks
"vb_Sagacious" wrote:
Using Access either "Link" the spreadsheet as a table or import the excel data.
Otherwise research ADO and CreateTable to learn how to push the data cell by
cell.
Ken
"Jac" wrote:
Hi,
I have been trying to create a macro in excel to automatically export data
into access, but to no avail. Would somebody please give me a hint?
Your assistance will be greatly appreciated.
Thanks
|