View Single Post
  #3   Report Post  
Jac
 
Posts: n/a
Default

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